Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Loop for checkbox
Name:
Steeve Allaire
Email (spam proof):
Email the originator of this post
Date:
Tuesday, July 20, 2004
Hits:
58
Discussion (Terms and Conditions):
HI ! I have 100 checkbox in my userform and I want to make a loop to put data in worksheet. I identified my checkbox like that chk1, chk2, chk3,.... I want to loop like this: for i = i to 100 if chk(i)= true then activecell.offset(0, i) = true How can i program this thanks for your help

Sponsored by the best FTP application on the internet: