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
Duplicate post, thread closed. Please take a few minutes to re-read the forum rules.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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 iconat the bottom left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks