problem with command button

[kevin lazell]

hi guys
i have 3 command buttons on my worksheet and if i right click on any of them
then assign macro i do not get the option to edit the code where the edit button should be i get new instead
can someone point me in the right direction to get the edit option back please

 

[dmt32]

ActiveX controls work differently to Forms buttons. There is no Assign Macro option what you do is click on View Code in the menu. This inserts an event procedure in the code module behind the worksheet containing the button. You call your macro from this event.

Private Sub CommandButton1_Click()

Call MyMacro

End Sub

Dave

 

[kevin lazell]

hi dmt32
i have changed all the buttons to activex control buttons but they do not activate when selected.
normally you would get your curser arrow when you hover over them, but i get a cross when
hovering over them. i dont understand call mymacro can you explain please

 

[dmt32]

Hi,
The Control needs to be in Design Mode (Option next to Insert on Developer Tab) - This allows you to select the control. Right Click & select view code option.

For more detail, Follow this guide: How To: Assign a Macro to an ActiveX Control - Peltier Tech

Dave

 

[kevin lazell]

hi
thanks for that it now works cheers kevin

 

[dmt32]

hi
thanks for that it now works cheers kevin

welcome - glad resolved & appreciate feedback

Dave