ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Required field message - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/25128-required-field-message-excel.html)

Steve S via OfficeKB.com

Required field message - Excel
 
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

Nick

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




Steve S via OfficeKB.com

Thanks Nick, good idea

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


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com