ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Force a field to be completed (https://www.excelbanter.com/excel-worksheet-functions/105573-force-field-completed.html)

kellyhilde

Force a field to be completed
 

I am developing "forms" in Excel 2000. The employee will tab to each
field that needs to be completed. (via unprotecting the cells and
protecting the worksheet).

However what I can not figure out is how to "force" them to complete
the field and not be able to tab to the next field. I have tried a
number of things including "data validation" options, but have not had
any luck.

Anyone have any idea????


--
kellyhilde
------------------------------------------------------------------------
kellyhilde's Profile: http://www.excelforum.com/member.php...o&userid=37651
View this thread: http://www.excelforum.com/showthread...hreadid=572606



All times are GMT +1. The time now is 09:04 AM.

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