Activate Column after locating text in a row

  • Thread starter Thread starter Smythe32
  • Start date Start date
S

Smythe32

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