Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zebra99
  • Content: Threads
  • Order by date
  1. zebra99

    VBA Color code

    How would you write VBA code to complete the following. If any of the previous 2 cells were yellow then orange If any of the previous 2 cells were orange then red If any of the previous 5 cells were red then purple If any of the previous 5 cells were purple then purple Thanks in advance!
  2. zebra99

    VBA Lookup???

    I have the following code that I need to modify to count the cell only if it is 3 or above and the value of the cell would be value -2. Maybe some kind of lookup function with the following table? 0 0 1 0 2 0 3 1 4 2 5 3 6 4 This modified value would be for all cells in the offset. Then when...
  3. zebra99

    End if cell is blank

    I have the following code working perfectly, but need to add one thing. If the current cell is blank I want the select case code to be ignored. Can you help? Private Sub Worksheet_Change(ByVal Target As Range) Dim oCell As Range For Each oCell In Range("I10:Z22") myTot =...
  4. zebra99

    VBA conditional formatting with a formula

    The code I found below works great except I need the case or lookup to be based on the sum of the active cell and the previous 5 cells. This is similar to the Formula Is function of traditional conditional formatting. How would this be incorporated to the code below? Private Sub...

Part and Inventory Search

Back
Top