forcing user input into cells

  • Thread starter Thread starter georgio
  • Start date Start date
G

georgio

howdy all... i'm new to doing stuff with excel
have a bit of a background in javascript programming

what i'm trying to do is force a user to enter something, anything int
a specific cell
if the user tries to tab past the cell and leave it blank, i want a
error to come up, telling them that they have to enter something befor
they can continue on with entry into other cells

any help would be much appreciated
-Thank
 
If you have the sheet protected and certain individual cells that a user
would enter info in not protected, and if the user is using the tab key it
will take them to to next unprotected cell.

Saying that if the user is indeed using the tab key they will eventually
come to the cell that you are talking about.

You could put a comment in through data validation telling the user that
they must enter in some type of info.

I am sure there is a better way, but I am new to all of this myself.

John Kitchens
 
Back
Top