Drop down list - link to another worksheet
 

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.

Drop down list - link to another worksheet
 

I don't know why, but I could not upload attach :(
"DVAL" wrote in message ...

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.

Drop down list - link to another worksheet
 

On Nov 21, 11:26*pm, "DVAL" wrote:
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

Drop down list - link to another worksheet
 

On Mon, 22 Nov 2010 02:39:41 -0800 (PST), NOPIK wrote:

On Nov 21, 11:26*pm, "DVAL" wrote:
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

But they are not links.

Drop down list - link to another worksheet
 

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

"NOPIK" wrote in message
...
On Nov 21, 11:26 pm, "DVAL" wrote:
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