Drop down list - link to another worksheet

D

DVAL

Hi

How to make Drop down list (Form Control - Combo box)
with names of worksheets and then when I select a list
value that I created I want to go to another worksheet.

SO, I want to pick one name from Drop down list and that worksheet then
opens!

What code do I need to enter? I have tried:
Sub DropDown1_Change()
If DropDown1.Value = "1" Then
Sheets("Ivan").Select
ElseIf DropDown1.Value = "2" Then
Sheets("Marko").Select
ElseIf DropDown1.Value = "3" Then
Sheets("Pero").Select
End If

End Sub
Examle is in atttach!

Does anybody know?
Thank you for reading this especially if you are able to help me out on
this.
 
N

NOPIK

Hi

How to make Drop down list (Form Control - Combo box)
with names of worksheets and then when I select a list
value that I created I want to go to another worksheet.

SO, I want to pick one name from Drop down list and that worksheet then
opens!
for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT
 
D

DVAL

Hi
I don't understand what did you mean with that?
;(

Hi

How to make Drop down list (Form Control - Combo box)
with names of worksheets and then when I select a list
value that I created I want to go to another worksheet.

SO, I want to pick one name from Drop down list and that worksheet then
opens!
for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT
 

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

Top