Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I placed a command button on my User form. How can I assign my print_Invoice
macro to this button? Or is there an easier way

I tried right click but cant see the option when in Vb mode

Thanks for help

Steve
 
There are 2 types of command buttons. Depending on the version of xl you have
how they are accessed.

In pre xl 2007 versions: Forms button is created from a button on the Forms
toolbar. ActiveX button is created from a button on the Control Tool Box tool
bar.

In xl2007: Both types are created from the Insert button on the Developer
ribbon and the two types are designated in the drop down.

With a Forms button you right click and select Assign macro.

With an ActiveX control you have to click on the Design Mode button (a
button with a blue set square, ruler and pencil) and then right click the
control and select view code. It will take you into the VBA editor at the
Sheet level and create a sub name and end sub where you place your code.

After right clicking on an ActiveX control, you can also set the properties
for the control.

Note: Design mode turns on automatically when you initially create an
ActiveX control.

You have to turn Design mode off before you can use the control.

Regards,

OssieMac
 
Back
Top