Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-30-2016, 11:36 PM
unwanted unwanted is offline Using check boxes and moving to start of document Windows 7 64bit Using check boxes and moving to start of document Office 2013
Novice
Using check boxes and moving to start of document
 
Join Date: May 2016
Posts: 2
unwanted is on a distinguished road
Default

Thank you for you're response.

I started trying to work out how to do that then thought i'd try what I was doing yesterday one more time and now I have it working with using an AND statement e.g.

Code:
If q1c.Value = True And q1a = False And q1b = False Then
   a1.Caption = "Correct"
Else
  a1.Caption = "Incorrect"
End If
Only shows correct if only the correct box or boxes are checked.

I tried the same thing yesterday but it kept giving me a
Compile error:
Expected: Then or GoTo

When it would get up to the first "And" but today it is accepting it fine.

Still a little more cumbersome than I would like but at least it works properly and is still much shorter than before.

My question now would be, for the reset button I list each checkbox and give it a .Value of false, would there be a way to just tell it to give every checkbox a .Value of false instead of having to list every single checkbox?

Thank you for your time.

Last edited by unwanted; 05-30-2016 at 11:39 PM. Reason: formatting
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro (or something) to run Spell Check within rich text content boxes in lock document NMBELL Word 8 12-21-2015 04:09 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM
Using check boxes and moving to start of document Check boxes display funkyspirit Word 3 05-23-2012 08:39 AM
Using check boxes and moving to start of document Check Boxes jellyrolls Office 4 07-15-2011 08:07 PM
Problem with Developer Form -- Check Boxes and Text Boxes PCC Word 1 05-16-2009 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft