Combo box and VB script help

[ethernet]

Greetings,
I am having problems with a combo box.

I need a Combo Box to Hide or Show colums upon selection.

For Example.

Option 1 -> Hide Column A
Option 2 -> Hide column B
Option 3 -> Show all columns etc etc.

I've been experimenting with the following code to no avail.


Private Sub ComboBox1_Change()
Columns("A:A").Select
Selection.EntireColumn.Hidden = True
End Sub

I'd really appreciate some help.

 

[ethernet]

Figured it out.