+ Reply to Thread
Results 1 to 2 of 2

Checkbox error message

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Checkbox error message

    Hi,

    I'm playing around with checkboxes for the first time and dipping my toes into VBA and really could do with a little help from those with a far better understanding than me.

    I've got a check box in one cell (checkbox1) and I also have another cell (we'll say "D10") and what I am trying to do is link an error message box to appear when the checkbox is selected and if the cell contains either a 1 or 7 (Sunday, Saturday).

    The idea being that if someone clicks on the check box and the Weekday in cell "D10" is either a Saturday or Sunday a message box appears and warns them that they've selected a weekend day (which they can do in certain circumstances but need the error message to warn them of the fact)

    Any help gratefully received.

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Checkbox error message

    You can link the checkbox to a cell, say C10, so that that cell displays TRUE/FALSE and then use a formula like:
    =iF(AND(C10,OR(D10={1,7})),"Danger, Will Robinson","")
    Good luck.

+ 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