Hyperlinked Drop Down List

[Pipestew]

I proposed this question the other day and recieved a helpful answer, but I am still confused and struggling with the problem....

I want to create a drop down list that allows me to make a selection from a group of choices. When I click on the selection, I want to be directed to a hyperlinked worksheet (in the same workbook). Creating hyperlinks is not a problem for me, but having them act as a hyperlink in the drop down list is generating a problem.

Any help is greatly appreciated.

[Dav]

If you choose a list box as a control, you can have a macro attached to an action on it to take you to the other sheet, but it is not a hyperlink, but does the same thing

Why not attach a file with what you want to do in it

Regards

Dav