Mandatory field in form

C

Carole O

Excel 2003

I have designed a form and do not want one of the fields to be skipped. It
must be filled in. I have tried Data Validation > 0, and unchecked Ignore
Blank, but I can cursor right by it. I want the cursor to stop on the cell,
and not leave until it is filled in. The format (GL Acct) is
nnnnnn-nn-nn-nnn. How would I put that in?

TIA,
Carole O
 
F

Frank Kabel

Hi
not possible without using VBA. Data Validation alone is not able to
achieve this behaviour
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Main Form Mandatory fields 1
Check mandatory fields using VBA not working properly 12
Mandatory field 4
mandatory form fields 1
Mandatory Data Fields 1
Form/subform navigation 4
Making a field compulsary before user leaves sheet 3

Top