Mandatory field in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
not possible without using VBA. Data Validation alone is not able to
achieve this behaviour
 
You must log in or register to reply here.

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

Main Form Mandatory fields 1
Mandatory Data Fields 1
Mandatory field 4
Making Cells Mandatory and Running Checks 3
Check mandatory fields using VBA not working properly 12
Excel Excel - creating mandatory fields 0
Conditional mandatory fielld ? 0
mandatory form fields 1

Back
Top