If you force the user to input something then you can expect a lot of junk to
be entered. Generally speaking a better option is to flag the cell in an
obvious way such that the user is aware of the requirement. Use formulas,
conditional formatting and data validation for that. You can also use some
code to prompt the user to make the input at some point (like switching
sheets) that the input is required.

--
HTH...

Jim Thomlinson


"Michele" wrote:

I have a spreadsheet that I want to require the user to add input before
going to the next cells. Does anyone have any idea how to do this?

thanks