Posted to microsoft.public.excel.programming

x taol

external usenet poster

Posts: 101

parameter

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 ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to choose if I use a parameter or not in a parameter query	Arnaud	Excel Discussion (Misc queries)	0	March 8th 07 01:19 PM
What does this parameter mean?	ManKind	Excel Programming	1	June 5th 06 06:05 AM
The parameter is incorrect	overcanyon[_2_]	Excel Programming	7	January 31st 06 06:53 PM
What does the second parameter in ACCRINT do?	Boris	Excel Worksheet Functions	0	January 6th 06 01:08 AM
parameter value query	Brad Vontur[_2_]	Excel Programming	0	April 6th 04 04:46 PM

All times are GMT +1. The time now is 08:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us