Changing font colour on locked text box

49 Views Asked by At

I am a newbie with VBA, so please be patient with me. I have a text box I don't want the user to modify directly only through user form. But if I set text box to enabled false then the font colour changes to default grey, which I don't want because it does not look good in terms of design (I generate PDF files from there) so my question is is there any possibility to change this locked text box font colour to something else for example blue or is it standard and cannot be manipulated? Thanks

I tried ChatGPT and various sets of VBA codes but that changed only the colour of text box when it was enabled=True, not when enabled=false.

0

There are 0 best solutions below