Issue with trying to pass name of command button as a variable

Hello All,

I'm trying to pass name of the command button as a variable to ButtonName first before setting cmdButton.

The name of the button is "Button_CalculationMode"

Please Login or Register  to view this content.

Alternatively, if I were to set the button name directly, such as below, it works.

Please Login or Register  to view this content.

No matter what I've tried from researching online, I keep getting various run-time errors such as 438: object doesn't support this property or method., or type mismatch errors.

I am fairly new to vba. Thanks in advance!

Try using this syntax

Please Login or Register  to view this content.