Ok, you want to assign the macro to that combobox then. Depending on
type of combobox you are using, when you right click on the combobox,
you want to select either "Assign Macro" or "View Code"

If you select Assign Macro, then in the Macro pop up box, select the
Macro that has the code in it. If you have to select Vew Code, then in
the new window, copy and paste the code into it. This one will change
the macro name to the combobox name.

ie. (View Code)
Private Sub ComboBox1_Change()

'enter code here'

End Sub


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