Good way to mark a textbox so users know it is required to fill

[Ryanchris]

Hi all!
Simple question from a new vba user. I have forms that have several textboxes. Some the user is required to fill in, and others not. These are for surveys...

I'm just looking for an easy way to mark that a tb is required so that it's obvious and different from the optional tb's.

What is commonly used? I'd really like something with a simple code as I'm pretty new to this. Could use the opinion of frequent users and developers so BIG THANK YOU in advance !!!

[paulked]

I tend to change the background colour on optional items and the put a check in for compulsory, as in:25699

[Ryanchris]

Got it. That works for me.

Thank you!

[paulked]

You're welcome :thumb

[Paul_Hossler]

If you want to get a little fancy

25704

I also added Control tip text 'instructions'

[Ryanchris]

I love this one. Using it! Thank you!