since it's 6 different comboboxes, then unfortunately, yes...you would
have to write a command for each box. However, what you can do, is
call upon 1 macro in each box.

ie.
Sub Loop_1()
'all the code'
end sub

Private Sub dropdown1_change()
Loop_1
end sub

Private Sub dropdown2_change()
Loop_1
end sub

etc...so you only will have 1 instance of the macro, but 6 instances of
the combobox calling on the macro.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=481021