List Box: How do you enable link?

[highndry]

Hi

I have created this list box where I have around 10 tab (worksheet) names (AFD, AFS, CB&T, etc.). How can I redirect to those tab when someone select a name. I can use hyperlink but then I would have to type in all the tab name and it will take up too much space.

Thanks

 

[Smitty]

All you need is:

Private Sub ListBox1_Change() 
    Sheets(ListBox1.Value).Select 
End Sub

The redundant code will cause an error.

Smitty

 

[highndry]

Ok I was wrong, it looks now that the list box is actually a combo box inserted from "Forms". That's why it is asking to assign a macro.