Force required entry in cell before leaving that cell

  • Thread starter Thread starter Retired Bill
  • Start date Start date
R

Retired Bill

In my worksheet, which has several columns, I do NOT want the user to be able
to leave a cell in the roll they are working on, UNTIL they have made an
entry.
 
Bill
There are several ways that a user can be compelled/notified to make an
entry in a given cell or row, but more information is needed from you to
make this work. Specifically, what do you want him to do? What can he do
that you DON'T want him to do? HTH Otto
 
I want the user to have to make an entry into the cell BEFORE moving to the
next cell. I do not want the user to be able to leave that cell WITHOUT
making an entry. Thanks
 
How will Excel know the user has not entered something if user cannot leave
the cell in some manner?

Excel will sit there forever with the cell in edit mode unless you give
Excel the word to move.


Gord Dibben MS Excel MVP
 
Bill
I don't know your business but maybe something like this might work. If
he attempts to save the workbook or close the workbook or move to another
sheet, you can have an event macro fire. This macro can check whatever
cells you want checked. If things are not like you want them, the macro can
cancel his command to save/close/change sheets, and pop up a message box
saying whatever you want. Would something like this work for you? HTH
Otto
 
That sounds similiar to what I need. I have a excel budget spreadsheet. It is
already set up that if they skip a cell, the formula that calclulate show an
error. The problem I now have is that they just keep entering and ignore the
errors. I want it to stop them from leaving a cell blank regardless of where
they are, not just if the click on the cell and then leave. I already have it
set up that there is a drop down box there with the data validation and it
does a stop if they enter wrong info, but it does nothing if they skip the
cell. Please help.
 
Back
Top