Force required entry in cell before leaving that cell

[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.

 

[Otto Moehrbach]

The roll? What is that? HTH Otto

 

[Retired Bill]

Sorry, my mistake - it should read ROW

The roll? What is that? HTH Otto

 

[Otto Moehrbach]

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

 

[Retired Bill]

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

 

[Gord Dibben]

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

 

[Otto Moehrbach]

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

 

[Michelle Drovdahl]

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.

 

[Gord Dibben]

Michelle

Have a look here for similar situation and some possible methods.

http://tinyurl.com/df4vlm


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 14:15:08 -0700, Michelle Drovdahl <Michelle