Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
goto row
Private Sub Combobox1_Click()
sStr = Combobox1.Value With worksheets("Sheet1") .Activate .Columns(2).Font.ColorIndex = xlAutomatic Set rng = .Columns(2).Find(What:=sStr, _ After:=.Range("B65536"), _ LookIn:=xlValues, _ LookAt:=xlWhole, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False) If Not rng Is Nothing Then rng.Select rng.Font.ColorIndex = 3 Else MsgBox sStr & " not found" End If End Sub -- Regards, Tom Ogilvy "geebee" (noSPAMs) wrote in message ... hi, Let's say I have a combobox in a sheet, with values. Whenever a value is selected, I want the sheet to move to the first occurence of that selected value in column B. How can this be done? I would also like for that value's cell be colored in red. Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF then GoTo | Excel Programming | |||
When To use GOTO Sub? | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming | |||
Goto next used row | Excel Programming |