checke boxes and msg
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Checke boxes and msg box

Checke boxes and msg box

resolvedResolved · Urgent Priority · Version 2003

replyReply Wed 12 Nov 2008, 16:40Delegate Tally said...

Tally has attended:
Excel VBA Intro Intermediate course

Checke boxes and msg box

Hi

I am trying to write the code so that a msg box appears if several check boxes are unticked....

If checkbox 1 = false and
Checkbox 2 = false and
checkbox 3 = false and
checkbox 4 = false then

msgbox("must complete minimum of one")

Else

Do nothing

Pls help cant get it to work...

Thanks
Tally

For upcoming training course dates see: Pricing & availability

replyReply Thu 20 Nov 2008, 14:08Trainer Jacob said...

RE: Checke boxes and msg box

Hi Tally

Thanks for your post. We may be able to assist with this but it does fall outside of the scope a standard forum post.

If you can send us the file you are working on and list any other issues you are having we will then be able to confirm:

1) If we can provide a solution
2) The time and cost to do this

If you then wish to proceed we can get this booked in, please let us know.

Kind regards

Jacob

Thu 27 Nov 2008: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard