Assigning a Sub Routine to an ActiveX control in worksheet?

[danny2000]

Well I used to be good at all this but for some reason I can't seem to get my ActiveX Command Button control on my worksheet to see the Sub Routine I assigned to it.

When I click on the button, I just get 'Sub or Function not defined'.

I've clearly forgotten something here. Where am I going wrong?

[Croweater]

Could be a number of reasons. Put up your worksheet, that might be a good start.

[danny2000]

Could be a number of reasons. Put up your worksheet, that might be a good start.

I can't do that. There are reasons.
The ActiveX control seems to be the problem. The normal excel worksheet controls work fine in this regard.

You say there's a number of reasons. Are you able to suggest a few?

[skywriter]

With an activex command button you would click the developer tab choose to go into design mode, right click on the command button, choose view code on the popup menu and call the routine you wish to use from within the command button click code.
Is that what you did?

[danny2000]

With an activex command button you would click the developer tab choose to go into design mode, right click on the command button, choose view code on the popup menu and call the routine you wish to use from within the command button click code.
Is that what you did?

Yes, that's what I did.. Done it thousands of times, but for some reason it's now not seeing my sub routine.
I have to paste the contents of that sub routine directly into the Command Button click event procedure.

------------------------------------------------------------------Update.
Actually, I just solved it.
I write the macro into the worksheet module instead of opening a new module and putting my code in that.

Rooky Error it seems!