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
 
Top