How to check if a option button was not selected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What do you have to check it against to see if an option button was not
selected. Here is what I had but am getting an error.

ElseIf (Me.Option4.Value = -1 And Me.Option6.Value = -1) Then
...
End If
 
What is your error? You may be having a problem with null values. You can put
Nz([Option4])=-1 then...

You do not need the .Value on your if statement.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Applying Code to a Column 0
Query format 1
Optional argument as Variant not acting like number 4
Can Vba workout if a selection is part of a group? 0
Option Button Stays selected 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Message box called if 1 of 3 options is entered. 4

Back
Top