I wasn't sure if this question should go into "UserForms" or "VBA". Please help me repost if I goofed...



I would like to add a drop-down list called "Results" to a form. The list would have three options: "PASS," "FAIL," or "NA/Not Tested." I would like to format the text of the selected option so that "PASS" appears in green, "FAIL" appears in red, and "NA/Not Tested" remains unchanged.

Can anyone help me accomplish this? I can create the drop-down, and populate the list, but I can't figure out how to wrap any code around it.