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?
|