How to activate command button on form by macro

[Denis]

I'm working on a macro to load, fill out, and run a form. I think I
know how to do everything except run the form. By run the form I mean
"click" the OK command button.

Here's basically what I have (in the same workbook as the form):

Load MyForm
MyForm.textbox = "some text"
MyForm.OKbutton.SetFocus
Application.SendKeys "{ENTER}"

I thought I could set the focus to the OK command button and send the
ENTER key but that isn't working. Should this work or is there some
other way to click the OK command button?

Denis

 

[Jim Thomlinson]

By default when you created the OKbutton the click event procedure will be
private so it will look something like...

Private OKbutton_Click()

This means the the procedure is not exposed outside of the form. To expose
it you just need to change it to Public

Public OKbutton_Click()

Now you can call it like this...
call MyForm.OKbutton_Click()

You do not need to load the form. In fact that will halt the execution
waiting for user input on the form.

 

[Denis]

By default when you created the OKbutton the click event procedure will be
private so it will look something like...

Private OKbutton_Click()

This means the the procedure is not exposed outside of the form. To expose
it you just need to change it to Public

Public OKbutton_Click()

Now you can call it like this...
call MyForm.OKbutton_Click()

You do not need to load the form. In fact that will halt the execution
waiting for user input on the form.

Thanks. I wondered if that was the right approach or if there was a
better or right way to do this.

Denis