Data validation

B

Bill

I have a validation list on sheet 1 and I need the selection from that list
to take me to sheet 2 or sheet 3
 
M

Marcelo

Hi Bill,

you can't, a list for data validation porpose must be on the same sheet

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bill" escreveu:
 
B

Bill

Can I do it with a button if I get my selection from the data validation
list, if so how
 
G

Gord Dibben

Bill

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
Select Case Target.Value
Case "1"
Sheets("Sheet1").Select
Case "2"
Sheets("Sheet2").Select
End Select
endit:
Application.EnableEvents = True
End Sub

This is sheet event code.

Right-click on the sheet tab and "View Code". Copy and paste into that module.

Adjust range and parameters to suit.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

Or even just a =hyperlink() formula in an adjacent cell:

=IF(A1="","",
HYPERLINK("#"&CELL("address",INDIRECT("'" & A1 &"'!x99")),"Click me"))

Will take you to x99 of the worksheet that's in A1.
 
Top