Closed Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    06-04-2008
    MS-Off Ver
    2007
    Posts
    37

    Automaticly selecting check boxes

    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

  2. #2
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,134

    Re: Automaticly selecting check boxes

    Duplicate post, thread closed. Please take a few minutes to re-read the forum rules.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    02-15-2008
    Location
    Grappenhall, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    5,826

    Re: Automaticly selecting check boxes

    Hi

    How about something like

    Code:
    =IF Checkbox1 Or Checkbox2 Or Checkbox3 And Textbox1 = "" Then Checkbox4
    ?
    Rgds
    Richard Buttrey

    If this was useful then please rate it appropriately.

    Click the small star icon at the bottom left of my post.

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.2.0