I am creating a form in Excel and have cretin fields that must have
information entered before moving to the next field. Is there a way to have
a message pop up (Information is required) if the field is left blank. I’m
new at using VB and any help would be greatly appreciated.

Thank you,
Steve

Steve
One suggestion is
Try using the exit event for the control and have a procedure to test the
entry.

Hope this helps.

Nick
"Steve S via OfficeKB.com" wrote in message
...
I am creating a form in Excel and have cretin fields that must have
information entered before moving to the next field. Is there a way to
have
a message pop up (Information is required) if the field is left blank. I'm
new at using VB and any help would be greatly appreciated.

Thank you,
Steve

Thanks Nick, good idea

--
Message posted via http://www.officekb.com