Checkbox MsgBox

[Denzil]

Hi everyone

Ive got some code that I hope somone can help me modify to do what I need It to do.
Ive got numerous checkboxs that get ticked as options, I need to create a code that allows the following to take place: if 2 or more checkboxs from C58 to C66 are checked for a message box to appear.

Then if the above is true and the user checks either C67 or C68 then another message box appears

Can anyone help please?

Many Thanks

Denzil

[royUK]

Is C58 the name of the checkbox or a cell reference?

[Denzil]

Hi Roy

C58 is the cell reference

Many Thanks for response

Denzil

[Denzil]

-------bump-------

[Denzil]

Can anyone help please?

[Denzil]

Can anyone help or give me any advice please?

[royUK]

Your explanation isn't that clear, you might get more help if you attached an example workbook.

[Denzil]

Ok Thanks for your advice

Ive posted a short version of what I have

Many Thanks

Denzil

[Denzil]

Can anyone help today please??

[Denzil]

Im wondering if the following is possible:

Ive got numerous checkboxs that get ticked as options. I need to create a code that allows the following to take place: if 2 or more checkboxs from C58 to C66 are checked for a message box to appear.

Then if the above is true and the user checks either C67 or C68 then another message box appears

Can anyone give me any advice or code to start me off please? anything would be a great help

Many Thanks

Denzil

[Stuie]

Hi Denzil,

I havnt got the code to hand at min as am a bit busy, but i would suggest that you chould make a global function that loops though the checkboxs and counts how many are checked and then take the nessecery actions.

call the function from the click event for each of the checkboxs. and remember if you want to limit the checkboxs available to click you can always disable and enable them.

hope this helps

[Denzil]

Hello Stuie

Thanks for your reply,

What you described sounds great, the only problem is my lack of knowledge in excel, im bit of a novice, any chance of an example?

Thanks again

Denzil

[Stuie]

yea sure,

say i have 3 check boxs {ck1, ck2, ck3}

now if ck1 and ck2 are clicked then ck3 needs to be enabled else its disabled (hope im making sense )

my code could be

Please Login or Register  to view this content.

this is a very brief and simple example

[royUK]

I've added a formula and code to check this.

[Denzil]

Thats just what I wanted!!

Thankyou both for your help

Much appreciated

Denzil

[Stuie]

No probs Denzil, glad to help

[royUK]

Glad you got the solution, which did you use?