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?

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?