Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force an entry
Is there a way to force a user entry in a cell, before it will allow the user
to go to the next cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force an entry
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force an entry
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Use Validation to force specific entry of first 3 characters in st | Excel Worksheet Functions | |||
Validation to force entry in a cell | Excel Worksheet Functions | |||
Force entry to one of three cells | Excel Worksheet Functions | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) |