Hyperlink Button

[hanif]

Hi All,

I am having a combo box with sheet names drop down list which I like to be able to navigate through different sheet when selected from drop down list. I am able to do it with excel formula as below. I like to get help to apply this formula to a command button.

Please Login or Register  to view this content.

I also attached a sample for better understanding. You can change an item in the combo box and click cell D11 in Sheet1 to navigate to the selected sheet. I was wondering if I could do the same when I click the 'Go to Sheet' button.

Thanks,

[PCI]

Why not

Please Login or Register  to view this content.

[Artik]

You can also ask if this button is needed?
Assign a macro to "Drop Down 4" control:

Please Login or Register  to view this content.

Edit:
Oops, it should rather be like this:

Please Login or Register  to view this content.

Artik

[hanif]

Thank you both very much for your responses. I've got what I needed now.

Cheers,

[PCI]

Yes another one.
Just assign the macro to the dropdown

Please Login or Register  to view this content.