how do you do a loop in excel ?
I created checkbox in excel by looping ....
But then i want to retrieve the data from the loop how do i do thatDim 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