Kim

If you name the picklist range you can use it across worksheets.

Also see Debra's page on running code on Change_Events.

http://www.contextures.on.ca/xlDataVal08.html#Change

Gord Dibben XL2002

On Sun, 30 Nov 2003 11:57:43 -0800, "Kim" wrote:

I've seen this example but using validation functionality constrains to the
current worksheet or external file that must be open. I couldn't get it to
use a range outside of the current worksheet. I store all my picklist values
on a different worksheet that's why I use the combo box list instead because
it allows to select a range outside of the current worksheet.

Taking this approach, Is there a way to run a sub once validation list#2 is
selected? With this approach, I'dhave to create a button to call the
subroutine...correct?

Kim

"Ken Wright" wrote in message
...
Take a look here at Debra Dalgliesh's tip on dependent lists using Data
Validation - This may be a mor elegant way of solving your problem.:-

http://www.contextures.com/xlDataVal02.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
Newsgroups - Where you really can get a free lunch!!
--------------------------------------------------------------------------