Unanswered: Automatic txtfield value based on checkbox tickling & radio button, combobox, &listbo
I'm working on a sample checklist form application.
How should my VBA code look like when I want a corresponding textfield to have an automatic value based on tickling of a checkbox & changes color.
Ex. chkbox1 >>> txtfld1=passed (when tickled) (txt color=BLUE)
chkbox2 >>> txtfld2=Failed (when not tickled) (txt color=RED)
same thing goes with the radiobutton or a combo box or checkbox...