Force required entry in cell before leaving that cell
 

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.

Force required entry in cell before leaving that cell
 

The roll? What is that? HTH Otto
"Retired Bill" wrote in message
...
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.

Force required entry in cell before leaving that cell
 

Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in message
...
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.

Force required entry in cell before leaving that cell
 

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" wrote in message
...
Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in message
...
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.

Force required entry in cell before leaving that cell
 

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

"Otto Moehrbach" wrote:

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" wrote in message
...
Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in message
...
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.

Force required entry in cell before leaving that cell
 

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


On Sun, 15 Mar 2009 09:05:00 -0700, Retired Bill
wrote:

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

"Otto Moehrbach" wrote:

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" wrote in message
...
Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in message
...
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.

Force required entry in cell before leaving that cell
 

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
"Retired Bill" wrote in message
...
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

"Otto Moehrbach" wrote:

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" wrote in message
...
Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in
message
...
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.

Force required entry in cell before leaving that cell
 

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.

"Otto Moehrbach" wrote:

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
"Retired Bill" wrote in message
...
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

"Otto Moehrbach" wrote:

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" wrote in message
...
Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in
message
...
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.

Force required entry in cell before leaving that cell
 

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
wrote:

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.

"Otto Moehrbach" wrote:

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
"Retired Bill" wrote in message
...
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

"Otto Moehrbach" wrote:

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" wrote in message
...
Sorry, my mistake - it should read ROW

"Otto Moehrbach" wrote:

The roll? What is that? HTH Otto
"Retired Bill" wrote in
message
...
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.