Excel VBA Checkbox decisions are correct but graphical checkmark does not display
Posted on 2016-11-06
I have a multipage userform that writes values to various sheets then re-writes those values back to the controls when the userform is re-opened. One problem I have is that upon re-open and re-write, the checkbox value will correctly interpret its status (i.e, whatever decision it is controlling will function correctly) however, the graphical checkmark does not appear. The only way I have managed to re-install the graphical checkmark is to programatically turn the checkbox on and off as the userform opens:
If Checkbox1.Value = true then
Checkbox1.Value = False
CheckBox1. Value = true
ElseIf If Checkbox1.Value = False then
Checkbox1.Value = True
CheckBox1. Value = False
This is problematic however, because if I use this technique, I have to gather the decision making logic of the checkbox and then
re-install it as the checkbox turns on and off. Some of these checkboxes control quite a bit of data and it just seems redundant to re-configure data after I already have done it previously.
Any advice for me on this from the experts?