vba doubt

vino.spider

New Member
Joined
Apr 28, 2011
Messages
15
hi friends,
suppose for eg, i have 5 forms
namely f1,f2,f3...f5
i have to use for loop to increment i value to open all five forms in a loop


i have tried this..
sub loopp()

for i =1 to 5
" f "&i.show
msgbox form" &i"
next i
end sub
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Why in the world would you want to open up 5 (supposedly user) forms all at once? That is a very confusing and excessive interface for a user. There is probably a better way to present a user with an interface that's better than 5 sepaarte forms at once. What are you doing exactly?
 
Upvote 0
please explain me...
in other words.. i have ten labels l1,l2,l3....l10
for i =1 to 10
l&i.caption=i
next i


this throws me a error ...
i don't know how to use this i inside the label name...
plz do reply
 
Upvote 0

Forum statistics

Threads
1,224,591
Messages
6,179,769
Members
452,941
Latest member
Greayliams

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top