Going to worksheet based on answer

S

SAP PoD

Hi!

I am using Data Validation (List) to provide the user with, say,
options.

Lets say the options are A,B,C - depending on the answer, can I jump t
a seperate worksheet.

So, if 'A' is chosen, user is taken immediately taken to Worksheet
and so on.

Hope I explained the requirement OK.

Po
 
P

Pete_UK

Instead of data validation with a pull-down list, you could use three
hyperlink formulae, pointing to Sheet A, B and C, so that if you click
A you will be taken to A1 of Sheet A etc.

Hope this helps.

Pete
 
H

Harald Staff

Rightclick sheet tab, choose "view code", paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim S As String
S = Target(1).Value
If S = "" Then Exit Sub
On Error Resume Next
If Worksheets(S) Is Nothing Then Exit Sub
Worksheets(S).Activate
End Sub

HTH. Best wishes Harald
 
Top