If you are going to run nine procedures consecutively, then why not take them
out of the controls, rename them and put them in a module. Then you can
create a master procedure that calls the nine, as in the example below:

Sub master()
macro1
macro2
...
macro9
End Sub
Or, if you need to use a command button, then call them all from one
button's click event in a similar manner as the example above.

"x taol" wrote:

I have a Userform.
the userform have 9 button.
cmdBtn1, cmdBtn2, .... cmdBtn9
that buttons have a procedure respectively.
I want to run the button procedure using loop.

for example,

for i=1 to 9
application.run "cmdBtn" & i
next

but debug....
How can I.....

*** Sent via Developersdex http://www.developersdex.com ***