Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Column after locating text in a row
Data:
a1=combo box value row 3 I have column names like AA, BB,CC etc When someone selects a column name from the combo box, I need to activate that column. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Column after locating text in a row
Private Sub Combobox1_Click()
sStr = Combobox1.Value Application.Goto Columns(sStr & ":" & sStr), true End Sub Perhaps I don't understand the significance of AA, BB, CC and what is in Row 3. Regards, Tom Ogilvy "Smythe32" wrote in message om... Data: a1=combo box value row 3 I have column names like AA, BB,CC etc When someone selects a column name from the combo box, I need to activate that column. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locating text in spreadsheet | Excel Discussion (Misc queries) | |||
Ignoring blank cells while locating common text value | Excel Discussion (Misc queries) | |||
Locating the First Comma in a Text | Excel Worksheet Functions | |||
help locating first empty cell in a Column | Excel Worksheet Functions | |||
locating all instances of text in a column | New Users to Excel |