Linking DropDown box options to worksheets

Hi all,

Sorry if this has been asked before, I've done some research online and I couldn't find a solution, so I thought I'd ask myself!

Basically I have an intro page for a spreadsheet, with a DropDown box (couldbe Combo is thats easier) I need to have a series of options within the DropDown box, that when you click on it, links you to sheet within the workbook.

So far I have:

Please Login or Register  to view this content.

but I've also tried:

Please Login or Register  to view this content.

but I've had no luck with either! Can anyone help?

Thanks,

Chris

Welcome to the Forum chris2886.

However, your post does not comply with the Forum Rules you agreed to follow. Per Rule #3, all VBA code must be wrapped in code tags. Please edit your post to add the code tags, after which solutions to your question will be suggested.

Rule #3

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.

You may find this link helpful: Creating a Index Worksheet

Try adapting the code and use it in a validation drop down instead of a control from Forms or Control Tool Box.

Please Login or Register  to view this content.