Selection of Drop down list that allows you to go to a particular cell
 

Hi all,

I need help to do the following thing:

1. Have a drop down list (e.g. Scenario 1, Scenario 2, Scenario 3)
2. When user select (e.g. Scenario 2) from the drop down list and click
on a "Go" Button, it will take the user to the cell that says Scenario
2.
3. There will only be one Scenario 2 in the whole sheet.

Thanks a lot.

Selection of Drop down list that allows you to go to a particular cell
 

Hi Daphne,

Assign this code to your "GO" button.

Sub GoToIt()
If Range("F1").Value = "S1" Then
Range("A30").Select
ElseIf Range("F1").Value = "S2" Then
Range("F30").Select
ElseIf Range("F1").Value = "S3" Then
Range("L30").Select
End If
End Sub

Where F1 is the drop down value and change A30, F30 and L30 to suit your
sheet.

HTH
Regards,
Howard

"Daphne" wrote in message
ups.com...
Hi all,

I need help to do the following thing:

1. Have a drop down list (e.g. Scenario 1, Scenario 2, Scenario 3)
2. When user select (e.g. Scenario 2) from the drop down list and click
on a "Go" Button, it will take the user to the cell that says Scenario
2.
3. There will only be one Scenario 2 in the whole sheet.

Thanks a lot.

Selection of Drop down list that allows you to go to a particular cell
 

Thanks a lot. =)


L. Howard Kittle wrote:
Hi Daphne,

Assign this code to your "GO" button.

Sub GoToIt()
If Range("F1").Value = "S1" Then
Range("A30").Select
ElseIf Range("F1").Value = "S2" Then
Range("F30").Select
ElseIf Range("F1").Value = "S3" Then
Range("L30").Select
End If
End Sub

Where F1 is the drop down value and change A30, F30 and L30 to suit your
sheet.

HTH
Regards,
Howard

"Daphne" wrote in message
ups.com...
Hi all,

I need help to do the following thing:

1. Have a drop down list (e.g. Scenario 1, Scenario 2, Scenario 3)
2. When user select (e.g. Scenario 2) from the drop down list and click
on a "Go" Button, it will take the user to the cell that says Scenario
2.
3. There will only be one Scenario 2 in the whole sheet.

Thanks a lot.