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