VBA to click a button in a excel sheet

Question

i need to click a button(FormControl) on an excel sheet and run the macro assigned to it, through VBA code.

I tried what was suggested here https://stackoverflow.com/questions/130166/clicking-command-button-from-other-workbook but it didn't work for me.

Is there any other way to do this ??

Answer 1

Fairly easy method for doing this, even if it's not really documented.

CommandButton1.Value = True

Answer 2

Did you actually try? Because you want exaclty what is suggested there.

Application.Run Activesheet.Shapes(1).OnAction