Clicking a FORM CONTROL Button using VBA code.

Hello everyone,

Is it possible to "click" a form control button using VBA code?

Background:

I have a workbook whose VBA code is locked so I cannot see the macro. I can only give inputs and click on a "RUN" button [Form control button] to generate output.
I want to do this using a VBA code. It possible to put inputs and get the outputs but I am not able to figure out a way to actually 'click' the button programically.

The button is a form control button.
I do not have the access to the VBA code so I cannot call the macro associated with button.

For ActiveX buttons:
CommandButton1 = true ; will do the trick
I wanted to know if something like this is possible for FORM control buttons.

Thank you in advance!!

Hi mikerickson

It worked!!

Thank you so much for your help.

Mike, when I tried your code on a new worksheet with one button, I get this error message:

"Runtime error 9. Subscript out of range."

with the this line highlighted:

With Workbooks("Workbook1").Sheets(1).Shapes("Button 1")

1. Is the name of your workbook correct ?
2. Is your sheet with the button the first sheet in your workbook ?
3. Is your button a FORM control button or an ActiveX control button ?
4. Is the name of your button correct ?