Linking DropDown box options to worksheets

[chris2886]

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

[Palmetto]

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.

[chris2886]

Sorry! Now corrected

[excelxx]

Hi chris2886

Please can you confirm that the sheets you are refering to are in the same workbook.

Thanks

[Palmetto]

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.