Making cells compulsary to fill in on a worksheet

[Guest]

I am creating an application form to be used electronically. I want to make
sure that users fill in certain fields (cells). How can I make Excel tell the
user that when they click on 'close', they can not close or save the file
until all fields are populated? This is driving me mad!!!!

 

[Jason Morin]

J.E. McGimpsey posted some code to do just what you're
asking:

http://tinyurl.com/3kaos

HTH
Jason
Atlanta, GA

 

[Guest]

I don't understand the instructions! Sorry to bother you. Can you help?

 

[Jason Morin]

Press ALT+F11, and double-click on the "ThisWorkbook"
module underneath your workbook. It'll look like "VBA
Project..." Paste in all the code. Press ALT+Q to return
to Excel.

 

[Guest]

You're gonna hate me... How do I define exactly which fields need filling in
before the doc can be saved? I have never seen anything like that formula. I
am new to all this (though I guess that's pretty clear!)

Thanks for your help though.

Rob,
Teesside,
UK

 

[Jason Morin]

Where it reads:

Sheets("Sheet1").Range("A1, B2")

in the macro, change the sheet name and cell references
to what it needs to be. You can add more cell references,
just make sure to include commas. For example,

..Range("A1,B2,C4,G17,P100")

Jason

 

[Guest]

I haven't got a clue. It brings up the message "Compile error: User-defined
type not defined" This may as well be in Hebrew!

But thanks again for the help,

Rob.

 

[Dave Peterson]

Post what you've tried so far. It maybe easier to correct that way.