Create drop down menu using ActiveX comboBox

[Captain Flash]

Hello, I am new here, please be kind! I am trying to create a drop down menu that will fire different macros based on the selection from the ComboBox. I have been successful using form control ComboBox, but for flexibility I'd like to do this with an ActiveX ComboBox. I've attached (I hope!) a sample file. The macros work fine independently, but I get a "Object doesn't support this property or method" error when the "change" macro hits the "case" syntax... Any and all help would be greatly appreciated!

[davesexcel]

Possibly .listindex,
Starts at 0

Please Login or Register  to view this content.

[MickG]

Try this:-
NB:- the subs must be in a basic Module NOT sheet module.
NB:- Make sure you have the identical spelling

Please Login or Register  to view this content.

[Tinbendr]

Please Login or Register  to view this content.

[Captain Flash]

Davesexcel, this solution worked great! Thanks so much for a timely and elegant solution...
Captain Flash