How to loop through controls

[ImranBhatti]

Hello forum

A userform with this naming convention

ctrl1 ctrl2 ctrl3

aCtrl1 aCtrl2 aCtrl3 aCtrl4 aCtrl5
bCtrl1 bCtrl2 bCtrl3 bCtrl4 bCtrl5
cCtrl1 cCtrl2 cCtrl3 cCtrl4 cCtrl5
dCtrl1 dCtrl2 dCtrl3 dCtrl4 dCtrl5

cmdsave

there twleve such lines up to kCtrl

All I need to do is to transfer the values of these controls to my worksheet starting from A2 to H2 by clicking on cmdsave button I want the values of the first 3 controls(ctrl1,2,3) to be repeated with the bellow 12 lines controls
means the values of ctrl1,2 ,3 should go to column A to column C and the other 12 lines of controls's values should go to columnD to columnH (all the 12 lines are not neccessarily be filled .these can be less than12

How can these controls be looped in order to transfer their respective values to w/sheet?.

I will be greatfull to any help.

Best Regards
Imran Bhatti

[shg]

Please Login or Register  to view this content.

[TMS]

Something else to play with:

Please Login or Register  to view this content.

[ImranBhatti]

the values of ctrl1,ctrl2,ctrl3 are going to the their destination (in a2,b3,c3) columns. but the values of the bellow line i.e

aCtrl1 aCtrl2 aCtrl3 aCtrl4 aCtrl5
bCtrl1 bCtrl2 bCtrl3 bCtrl4 bCtrl5
cCtrl1 cCtrl2 cCtrl3 cCtrl4 cCtrl5
dCtrl1 dCtrl2 dCtrl3 dCtrl4 dCtrl5

are not reaching their. ok..let me remove the data and send the blank file.

[ImranBhatti]

here is the file

[ImranBhatti]

It seems there is some problems uploading my file. I tried repeatedly but not getting attached.

[Norie]

Click on GO ADVANCED, scroll down and click Manage Attachments.

[ImranBhatti]

Excel file is not uploading but I have attached the snapshots of both the userform and worksheet. Hope this will convey better what I want to do.

[ImranBhatti]

Thanks to all. Problem was solved by making some changes in naming conventions of userform controls and taking help from another thread of the same forum.

Best Regards
Imran Bhatti