can vba "click" a button

[tim963]

How would you run “CommandButton1_Click” from VBA, I want the Marco to “Click” the button on a user form, I have tried Application.Run "CommandButton1_Click" but it will not work I get “Marco commandbutton1_Click can not be found. Thanks excel ‘97

 

[PCLIVE]

Re: can vba "click" a button

Nice work. I got away with just:

Sheets(3).CommandButton1 = True

In my case, I'm in a userform and I'm invoking a CommandButton on a particular sheet.
Works great. I'm not sure about the "vbClick" line.

Is that necessary?

 

[awsmitty]

Re: can vba "click" a button

Thanks all, perfect thread

I'm new to vba and have used maybe 5 userforms in my life. Just wrote some code to run once a commandbutton is click. I then realized that wouldn't it be great if this code ran all on tis own as the form opens. Perfect!

thanks all. It's great when I can do a simple search and find the answer to my question. I love it