click the command button

I have a form with a command button, which leads to the next procedure if
clicked.

Sub CommandButton1_Click()
'process the info from form
End Sub

Now I am calling up this form in a loop. How could I click the button
automatically by vba?

Sub Main()
For i = 1 to 100
MyForm.show
'the command button on MyForm will need to be click to process info
Next i
End Sub

 

You don't, just call its procedure CommandButton1_Click.

--
----
Ed
----
I have a form with a command button, which leads to the next procedure if
clicked.

Sub CommandButton1_Click()
'process the info from form
End Sub

Now I am calling up this form in a loop. How could I click the button
automatically by vba?

Sub Main()
For i = 1 to 100
MyForm.show
'the command button on MyForm will need to be click to process info
Next i
End Sub

 

Sub Main()
For i = 1 to 100
MyForm.show
commandbutton1_click
Next i
End Sub

 

Hi Tom,

Shouldn't that be

MyForm.commandbutton1_click

just in case there are other commandButton1's on other forms in the project.

--


Laurie Comerford
CADApps
www.cadapps.com.au