How to make Drop List linking with a worksheet

  • Thread starter Thread starter Dani Lima
  • Start date Start date
D

Dani Lima

Hi guys!

I wanna a picture that have to be linked with two worksheets but it must
show just the one the user choose.

I was thinking on to appear a drop list with the name of the two worksheets
when click on the picture, and each name linked with the respective
worksheet. I tried hard to do this and i didn't. Can it be done?!!

Ex.: when clicked, the drop list has to show the options "X" or "y" or "z"
and then each option has to link to a worksheet with the same name.
 
Hi Dani,
I guess you could have the combo box (dropdown list) on or next to the picture with properties Enabled and Visible set to False. When a user clicks on the picture the macro should set those properties to True, making the combo box appear. Then depending on the choice from the combo box go to the selected sheet.
Does that help?
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
Drop down list - link to another worksheet 4
Plot graph depending on drop down box selection 1
Define the Range of a drop-down list 5
Drop List 1
Help with creating drop down 1
Three-way Lookup Help Please 5
Worksheet Linked with flags 1

Back
Top