PDA

View Full Version : Sleeper: Looping checkbox in excel



zoro85
09-04-2005, 11:21 AM
how do you do a loop in excel ?

I created checkbox in excel by looping ....


Dim h As integer
Dim chkbox As Integer
Dim an as Integer
Set chk = .Checkboxes.Add(g, e, 80, 10)
chk.Text = d
chk.Name = "Q" & h & "chkbox" & chkbox & "Ans" & An
g = g + 50
chkbox = chkbox + 1
Next

But then i want to retrieve the data from the loop how do i do that

Marcster
09-05-2005, 06:03 AM
Hi zoro85,

Have a look at this thread:

http://www.vbaexpress.com/forum/showthread.php?t=4806

Does that help?.

Marcster.