Louisville Slugger... Hit them first (makes their ears work better) then
explain what you want!!!
Lou

"Gord Dibben" wrote:

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

On Fri, 17 Nov 2006 08:11:01 -0800, Fusionmags
wrote:

I would like some help- I have designed a form were information needs to be
entered in certain cells, how can I force users into inputting this data and
not skipping cells

Gord Dibben MS Excel MVP