+ Reply to Thread
Results 1 to 5 of 5

Testing userform is complete

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    Norwich, England
    MS-Off Ver
    Excel 2007
    Posts
    56

    Testing userform is complete

    Hi all,

    This is probably very simple, so please accept my apologies for wasting your time!

    I have a Userform that holds a Multipage element each page of which is populated on the fly with frames containing two option buttons - Yes/No options.

    I want to check that each frame has one option button selected. I was going to try a For Each loop to iterate over all the controls on each page, but naturally, some of the controls aren't TRUE; it is their opposing partner that is.

    So, I can I check that each Yes/No question has been answered?

    I've done a screen grab which may help.

    Thanks,

    Steve. AuditGUI.JPG
    Last edited by OnlySteveH; 10-10-2012 at 08:26 AM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Testing userform is complete

    I've done a screen grab which may help.
    not as much as a workbook ;-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    08-19-2011
    Location
    Norwich, England
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: Testing userform is complete

    Quote Originally Posted by JosephP View Post
    not as much as a workbook ;-)
    Indeed!

    Not sure the wb helps massively; I've not started the code for this bit yet.

    Essentially, I want to implement the Submit button. That checks all the pairs have an answer on all pages of the Multipage.

    Hope that makes sense.

    S.

    Backup1.xlsm

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Testing userform is complete

    Please Login or Register  to view this content.
    note though that your code to create the controls is a little overzealous since your addcontrols and setframes routines both loop. change addcontrols to
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-19-2011
    Location
    Norwich, England
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: Testing userform is complete

    That works perfectly, thank you.

    And I hadn't spotted the pointlessness of that loop; thanks very much!

    S.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1