ExcelBanter - Force an entry

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Force an entry (https://www.excelbanter.com/excel-discussion-misc-queries/114621-force-entry.html)

Is there a way to force a user entry in a cell, before it will allow the user
to go to the next cell?

In Help look at Validation
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RKFLattop" wrote in message
...
Is there a way to force a user entry in a cell, before it will allow the
user
to go to the next cell?

You can put validation on the cell so user can enter only what you allow.

But what would you like to occur if user decides to just skip that cell?

Without some VBA it is impossible to "force" a user to enter something in a call
if they choose not to.

And then you must rely on macros being enabled when user opens the workbook.

And a contingency plan in the event they disable macros.

Gord Dibben MS Excel MVP

On Mon, 16 Oct 2006 11:01:02 -0700, RKFLattop
wrote:

Is there a way to force a user entry in a cell, before it will allow the user
to go to the next cell?