IF statement to enable/disable a checkbox in userform?

[cameronyoung]

Hi,

This seems like it would be simple enough to do but...

I have a checkbox called optComplete that I want to be disabled UNLESS:

1. The checkbox optoNewFF is checked, OR
2. The checkbox optoNewClient is checked, OR
3. An option in the combobox optqReasonNone is selected

I've tried loads of IF statements but I keep getting errors

Thanks in advance for your help.

[Norie]

Try this.

Please Login or Register  to view this content.

[cameronyoung]

Thanks so much for your reply. Really appreciate your assistance.

I thought this would need to be applied as follows, but I seem to have broken your code haha. I guess I need to also set for optComplete to be disabled when the form is intialized? Sorry for the noobness of me.

Please Login or Register  to view this content.

[Norie]

The only thing that might be wrong is that your combobox actually seems to be called qReasonNone, not optqReasonNone as you posted and I used in the code.

If that's right the code should look like this.

Please Login or Register  to view this content.

[cameronyoung]

Thank you so much!! Really appreciate it.

Couple more vba headaches to go and I am all sorted. Very impressed with the power of Excel+VBA / thought I would require an Access fix. Thanks again!!

C.