I do exactly what you want with 3 combo boxes.
combo1 is the main and determines what goes in combo2
combo2 thencontrols what goes in combo3
Where you are going wrong is that you need to use the
Click event not the change event
-----Original Message-----
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!!
-------------------------------------------------------
-------------------
.