VBA Code for a Required Cell

[mlr0911]

Hello All,

Does anyone know how I can require a cell to be filled out before it can be saved?

Example

When a user clicks "Save" if cell A3 is blank an error message will pop up and say "You must ........etc" and not save.

Thanks.

[Carim]

Hi,

Could the following help ...

Please Login or Register  to view this content.

HTH
Carim

[mlr0911]

Carim

It works, however the workbook is still saving. How can I avoid that.....Thanks again for your help.

[Carim]

Sorry ...
I typed code too quickly ...

Please Login or Register  to view this content.

HTH
Carim

[MSP77079]

I think Carim made a tiny error in the code. If A3 is NOT filled in you want to Cancel the Save. The way it was written, it will cancel the save only when A3 IS filled in. I think.

Try this just removing the Else.

Please Login or Register  to view this content.