Consulting

Results 1 to 2 of 2

Thread: Sleeper: Looping checkbox in excel

  1. #1

    Sleeper: Looping checkbox in excel

    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

  2. #2
    VBAX Mentor Marcster's Avatar
    Joined
    Jun 2005
    Posts
    434
    Location
    Hi zoro85,

    Have a look at this thread:

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

    Does that help?.

    Marcster.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •