Hi
in the most basic userform with a checkbox, one can go to the ControlSource section of the checkbox object's properties and type in "A1" where each time the check box is selected A1 will then say "true".
But what if I want the ControlSource for the checkbox tied to a value in B1, for example. Thus when B1=2 then the controlsource for the checkbox will change to A2.
TIA!
tx
in the most basic userform with a checkbox, one can go to the ControlSource section of the checkbox object's properties and type in "A1" where each time the check box is selected A1 will then say "true".
But what if I want the ControlSource for the checkbox tied to a value in B1, for example. Thus when B1=2 then the controlsource for the checkbox will change to A2.
TIA!
tx