Force input into certain cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I force entry into certain cells before other cells become available?

In simple terms I want users of my spreadsheet to be required to input their
name etc before being allowed to input into other cells.
 
JayW,

You can use Data - Validation on the other cells. Use Custom, and enter
=$A2<>""
This will test A2 for empty. This formula is for row 2. If there are two cells to test,
and both must be not empty, use
=AND($A2<>"", $B2<>"")
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
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.

You could just also use Condtional Formatting to color the cells that need
filling. when filled the color would disappear.

Nothing foolproof, just a reminder to users.


Gord Dibben MS Excel MVP
 
Back
Top