What do you want to trigger this code? Is it clicking on a command button?

Whatever the vent, it must go in the Userform module, not a sheet or
standard code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"abxy " wrote in message
...
I don't know where to insert this code into my UserForm code so that it
works...cause, from my understanding this code should work(but it's not
working), so it must just be in the wrong Private Sub. Here's the
code:

If checkbox1.Value = False And checkbox2.Value = False And
checkbox3.Value = False Then

CommandButton1.Enabled = False

Else

CommandButton1.Enabled = True

End If

and correct me if i'm wrong, but if a checkbox is not enabled, it's
value is considered false, right?

Thanks for your help


---
Message posted from http://www.ExcelForum.com/