+ Reply to Thread
Results 1 to 3 of 3

Can't get checkbox to go true from another userform

  1. #1
    Registered User
    Join Date
    07-06-2009
    Location
    Miami. OK
    MS-Off Ver
    Excel 2003
    Posts
    23

    Can't get checkbox to go true from another userform

    Hi everyone,
    This may have been asked and answered before, I have searched but have yet to come up with anything and have spent a lot of time trying to figure this out on my own. What I am trying to do is develop a electronic visitors log in excel that has three statements visitors must read and accept before they can enter.

    I have a userform with date/time, name etc, then the three buttons that open another user form with the statements for them to read and 2 command buttons (Accept and Decline), Accept takes them back to the log-in userform and Decline closes all forms.

    The problem I am having is I can’t get the checkbox on the log-in form next to each statement to go true when the accept button is clicked for said statement. I would like to disable the checkbox on the visitorsignin form so the only way it goes true is from the statement form.

    I hope I explained myself well enough for someone to understand what I’m trying to do, the code is not finished yet either, still waiting for signature pad to come in so I can paly with it and figure out how to incorporate it into the file.

    Thanks in advance for any help given,

    Martin
    Last edited by mhill; 08-14-2009 at 12:10 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Can't get checkbox to go true from another userform

    You are using the ME keyword in the wrong context.

    For the form, proprietarystate

    Please Login or Register  to view this content.
    In the other 2 userforms you need to add the VisitorsSignIn bit with the correct checkbox specified
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-06-2009
    Location
    Miami. OK
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Can't get checkbox to go true from another userform

    Thank you Andy.

+ 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