Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
choosing from drop down list
This code will change the font on the entire row red when "PRA" appears in
column H: Sub stantial() Dim myRange As Range Set myRange = Range("H8:H400") For Each c In myRange c.Select If c.Value = "PRA" Then Selection.EntireRow.Select Selection.Font.ColorIndex = 3 End If Next End Sub It works when you type in the letters, but when picked from a drop down list, it doesn't. Why would that be?? -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
Populate Multiple cells when choosing one selection from drop down | Excel Discussion (Misc queries) | |||
excel 2003 drop down time choosing | Excel Discussion (Misc queries) | |||
Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions | |||
choosing from a list in VB | Excel Programming |