Consulting

Results 1 to 2 of 2

Thread: looping checkbox in excel

  1. #1

    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
  •