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!

Checkboxes, AND, OR statements
 

the following pseudo code may give some ideas.

If ckbCoast = True And _
ckbSFR = True Then

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

End If

If (ckbCoast = True And _
ckbSFR = True) OR
(ckbCoast = True And _
ckbAdd = True) OR _
(ckbSFR = True And _
ckbAdd = True) Then

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

if clng(ckbSFR) + clng(ckbADD) + _
clng(ckbCoast) <= -2 then
Range("A168").Value = "O"
End if





--
Regards,
Tom Ogilvy



" wrote:

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!

Checkboxes, AND, OR statements
 

Thanks, this looks great. Also, is there a way to link the check boxes
between 2 different user forms (say ckbCoast is in frmLocal and ckbSFR
is in frmInfo)? Perhaps there's Hide Me function that would keep one
user form open, just not shown on the screen giving the next form the
ability to link back to it. Any ideas?

Checkboxes, AND, OR statements
 

No link like a controlsource.

You can link with code in events

Userform1.cbox1.Value = Userform2.cbox3.Value

Userform1.hide

hides the userform but doesn't unload it so you can still access its
controls (read from and write to)

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
Thanks, this looks great. Also, is there a way to link the check boxes
between 2 different user forms (say ckbCoast is in frmLocal and ckbSFR
is in frmInfo)? Perhaps there's Hide Me function that would keep one
user form open, just not shown on the screen giving the next form the
ability to link back to it. Any ideas?