Do not advance to next cell
Thanks Dave. I appreciate your help.
"Dave" wrote:
Hi,
Sorry, this one's a bit beyond me. Try posting again
Dave.
"helphv" wrote:
Hi Dave,
I would say at least in the first 1000 rows. My spreadsheet contains only 3
fields. We just want the end user to not be able to leave columns B & C
empty in a row once they have entered an ID number in column A. I am using
XL2003. I am also using Data Validation on columns B & C because only a
range of numbers are allowed. I have left Ignor blank unchecked.
Unfortunately, Tab and arrow key allow advancement. Thank you!
"Dave" wrote:
Hi,
Not sure I understand. Does the user have to enter data into every cell in
Columns B & C? That's about 130,000 entries in XL2003, and 2 million in
XL2007!
Dave.
|