Hi
why not use conditional formating. e.g.
- select cell B1
- goto 'Format - Conditional format'
- enter the formula
=B1=""
- choose a color

--
Regards
Frank Kabel
Frankfurt, Germany

"V-Man" schrieb im Newsbeitrag
...
Hi all,

I have a userform with various fields. Some fields are essential for
a user to fill out. Before a user saves the form, I want to be able to
flag the critical fields (maybe change their color) that have not been
completed and generate a message which indicates the specific fields
that need information. This is similar to when you fill out an
application online and the missing info is highlighted before you can
continue.

I can give more details if you need!

Thanks,

V-Man