ExcelBanter - Assigning A Macro to A Button

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Assigning A Macro to A Button (https://www.excelbanter.com/excel-worksheet-functions/173561-assigning-macro-button.html)

Holly

Assigning A Macro to A Button

Hi All,

How do you assign a macro to a command button?
--
Cheers,
Holly

Stefi

Assigning A Macro to A Button

In Design mode right click on the button, choose View code, insert
Call yourmacroname
in the CommandButton_click sub.

Regards,
Stefi

€žHolly€ ezt Ã*rta:

Hi All,

How do you assign a macro to a command button?
--
Cheers,
Holly

All times are GMT +1. The time now is 10:02 AM.