Data Validation [SOLVED]

bearcub · Apr 15th 2003

Can you Data Validation where the list source is in the same workbook but different sheet?

Or, does the list source have to be on the same page as the cell that contains its values?

Egad · Apr 15th 2003

You can have a list source on a different sheet if it is named range.

**royUK** · Apr 15th 2003

As Doug says, you need to name your list range and when setting up your validation in the source box type ="yourlist" (the name of your range)

bearcub · Apr 15th 2003

Thanks

Dave Hawley · Apr 16th 2003

Hi Guys

The named range method is the best choice in most cases. You can however, also use the INDIRECT function, e.g.

=INDIRECT("'Sheet1'!B1:B3")

Only advantage to this, over a named range, is if a user deletes the first, or last cell, in named range it gets the #REF! error.

Anonymous · Apr 16th 2003

Quote

Originally posted by Dave Hawley
You can however, also use the INDIRECT function, e.g.

=INDIRECT("'Sheet1'!B1:B3")

wow - I never knew that Dave ! are you gonna pop this in the "cool!" section ?

Dave Hawley · Apr 17th 2003

Hi Chris

Hmmm, I think I might post a thread on Validation list tricks in there. I have a few freebies for download on Validation.

Anonymous · Apr 17th 2003

just so long as you don't take the limelight away from my miraculous "pi" posting....

:lol:

hey, I read somewhere that the ancient Greek mathematicians once actually voted that pi was officially equal to 3.2 or something similar

now there's a culture that needed some VBA forums.....

:guitar:

Participate now!