Peter,

If you go into design mode (the blue-green triangle on the Control Toolbox
toolbar), then click the control, it will create an outline click event for
that control. Add your code in there.

--

HTH

RP

"Peter Bailey" wrote in message
...
I have added an active x contriol in a worksheet but dont know how to call
the method. in access I would go me.nameofcontrol.dropdown but I dont know
in excel.

regards in advance

peter