+ Reply to Thread
Results 1 to 9 of 9

Automatically selecting checkboxes

  1. 01-25-2010, 02:44 PM #1
    shy07014
    shy07014 is offline
    Registered User
    Join Date
    06-04-2008
    MS-Off Ver
    2007
    Posts
    37

    Automatically selecting checkboxes

    Hi, here is the situation:

    ive been trying to get this to work but no luck...

    Text Box: Email

    Check Box 1: newsletter
    Check Box 2: promotions
    Check Box 3: HolidayCard

    Check Box 4: BadEmail

    Heres what i need:

    if any of the checkboxes (1, 2 or 3) is checked, and there is no text in the text box, then checkbox 4 will get checked...

    however, i would still like a manual option with checkbox 4

    thanks in advance for all your help...

    shy
    Reply With QuoteRegister To Reply
  2. 01-25-2010, 02:51 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Automaticly selecting checkb boxes

    Hello shy,

    Where are these controls located: worksheet or VBA UserForm? If they are on a worksheet are the controls Form type or Control ToolBox type?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 01-25-2010, 03:32 PM #3
    shy07014
    shy07014 is offline
    Registered User
    Join Date
    06-04-2008
    MS-Off Ver
    2007
    Posts
    37

    Re: Automatically selecting checkboxes

    its a vba userform

    thanks
    Reply With QuoteRegister To Reply
  4. 01-25-2010, 04:25 PM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Automatically selecting checkboxes

    Hello shy,

    Here is the code for the UserForm. The Sub "CheckStatus" needs to be placed in the General Declarations section (Very Top) of the UserForm. Each check box except the last calls this code. This allows you to manually change Checkbox4.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-25-2010, 05:01 PM #5
    shy07014
    shy07014 is offline
    Registered User
    Join Date
    06-04-2008
    MS-Off Ver
    2007
    Posts
    37

    Re: Automatically selecting checkboxes

    ok, that worked fine in excel (thanx), but we decided to switch to access, and now im totally lost. how can i implement this into an access for...where do i put the macro??

    thanks alot


    ps: i guess this should be moved to access programming
    Reply With QuoteRegister To Reply
  6. 01-25-2010, 05:14 PM #6
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Automatically selecting checkboxes

    Hello shy,

    I don't know Access. You will need to repost in the Access Forum. Include a link back to this post so others will know what has been done so far.
    Reply With QuoteRegister To Reply
  7. 01-25-2010, 05:17 PM #7
    shy07014
    shy07014 is offline
    Registered User
    Join Date
    06-04-2008
    MS-Off Ver
    2007
    Posts
    37

    Re: Automatically selecting checkboxes

    ok great...thanks
    Reply With QuoteRegister To Reply
  8. 01-25-2010, 05:21 PM #8
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Automatically selecting checkboxes

    Hello shy,

    Actually, I can move this thread to the Access Programming forum for you.
    Reply With QuoteRegister To Reply
  9. 04-20-2010, 10:52 PM #9
    dmaesj
    dmaesj is offline
    Registered User
    Join Date
    04-19-2010
    Location
    San Diego, CA USA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Automatically selecting checkboxes

    All you should need to do is enter me. in from of all objects. This should be placed in the module of your form in VBA. I would also use the AfterUpdate event.

    Please Login or Register  to view this content.
    Last edited by dmaesj; 04-20-2010 at 11:17 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1