View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] CraigRichardPhillips@gmail.com is offline
external usenet poster
 
Posts: 6
Default Checkboxes, AND, OR statements

This is kind of similar to my last post, but I'm working with AND
statements again in VBA. I'm trying to enter a value into a cell only
if 2 or more different check boxes are marked off. Although this is
very very wrong, something like:

If ckbCoast = True

And

If ckbSFR = True Then

Range("A168").Value = "O"

End If

As another very incorrect example:

If ckbCoast = True

And

If ckbSFR = True

OR

If ckbAdd = True Then

Range("A168").Value = "O"

End If

Thanks for the help guys!