Data validation
 

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
--
Bill

Data validation
 

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:

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
--
Bill

Data validation
 

Unless you get that range a workbook level name:
http://www.contextures.com/xlDataVal01.html#Name
(from Debra Dalgleish's site)



Marcelo wrote:

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:

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
--
Bill

--

Dave Peterson

Data validation
 

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


"Marcelo" wrote:

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:

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
--
Bill

Data validation
 

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

On Wed, 16 Aug 2006 07:11:02 -0700, Bill wrote:

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

Data validation
 

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.

Bill wrote:

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

"Marcelo" wrote:

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:

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
--
Bill

--

Dave Peterson