Conditional Format a field based on the value in another field

[Lothar69]

In the attached workbook, I am creating a userform called frmTicketRequest. I have a combo box called cboSystem which has an option within the drop down of "Other". Immediately following that combo box, I have a label "Other System:" and a text field. I would like this label and text field to be grayed out and the text field locked to prevent entry unless the user selects "Other" from the system drop down. If this is the case, I would like the txtOtherSystem field to have a white background and for it to be unlocked and I would like the lblOtherSystem to have black font.

I'm having trouble with the specific vba code to handle this conditional formatting.

[antoka05]

See attached file. This is the code I added in combobox change event:

Please Login or Register  to view this content.

Regards,
Antonio

[Lothar69]

Thank you Antoka05! Works like a charm!