View Single Post
 
Old 05-30-2016, 11:36 PM
unwanted unwanted is offline Windows 7 64bit Office 2013
Novice
 
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