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.

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.

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.

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.

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.

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.

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.