Creating a drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a drop down list, that when a user click on a selction it
will take the user to a certain worksheet in the workbook
 
I create a drop down list, but I cannot find tab to that says view code?
 
Sorry about taking so long to get back to you. I was gone for lunch. There
are tabs at the bottom of the spreadsheet, which you can select to move from
sheet to sheet. If you right click on the tab you will get a menu allowing
you to Insert, Rename, Copy... The last item should be view code. If that
still is not working for you then you can go in through the VB Editor. Alt +
F11 is the quick way to get there. Once in the VBE on the left hand side you
should have a project explorer. double click the sheet you want and paste
the code...

HTH
 
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
Data Validation List problem 5
Populate list or combo box from closed workbook 4
Define the Range of a drop-down list 5
Input Box w/Drop Down List 4
Pick from drop-down list gives empty or erroneous result 6
Data Validation Drop Down Using VBA? 1
Drop down list - link to another worksheet 4

Back
Top