I have a number of textboxes in a Userform that will only require inputting in a minority of circumstances.

I have locked these textboxes to prevent input unless a checkbox has been ticked by the user to indicate they are required.

I wondered if there was a way to have these textboxes 'greyed out' when the checkbox is unchecked, and then return to the normal white/blank colour once the checkbox has been ticked / becomes live.

Thanks,
AJHEZ