Mandatory Fields in Excel 2000 1

[ScottXJ]

Hello:

I was wondering if there was any way to make a cell/field mandatory? I have a worksheet containing several cells that I would like to ensure the user completes. I'm familar with how to do this in Access, but for some reason, Excel has me stumped.

Any assistance would be appreciated.

Thanks,

Scott.

 

[TonyJollans]

Hi Scott,

In Access you can make a field in a record mandatory - checking being done when the record is committed. Excel doesn't really have the concept of record and the only real equivalent to committing a record is saving the workbook.

You can put code in the BeforeSave and/or BeforeClose events which can do any validation you like and prevent saving unless your criteria are met.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[