please help with vba checkboxes

I am new at this.
I have two checkboxes with each having a different value associated with them. When both are selected I have a combined value and this part works. The issue is when I uncheck one of the boxes it does not revert to the first command and gives the value of the checked box. It remains with the combined value until both are unchecked.

what I am looking for is to when checkbox1 is checked=a value
when checkbox2 is checked =a different value
when both are checked = a zero value
(i have that and it work)
when i uncheck one of the checkboxes and the other is checked it keeps the zero value. I want it to result in the checkbox that is checked.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)



After you apply code tags, please explain your code. There are four possibilities. What result do you want for each?

Checkbox1	Checkbox2	D87 Result?
TRUE	TRUE	?
TRUE	FALSE	?
FALSE	TRUE	?
FALSE	FALSE	?