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!!
----------------------------------------------------------------------------
"Kim" wrote in message
...
I have 2 drop down list on my spreadsheet. #1 is the master and #2 is based
on selection from #1.
For example: if a user select "Auto" in list #1, then in list #2, only a
list of Auto will be filled in.
My question is when I select a value in List#1 it automatically run both
subs combobox1_change and combobox2_change. It doesn't allow the user the
select the drop down list #2.
Can someone help me so that only sub combobox2_change runs only when drop
down list #2 is selected.
Thanks
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003