Making cells compulsary to fill in on a worksheet

A

abfabrob

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!!!!
 
J

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.
 
A

abfabrob

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
 
J

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
 
A

abfabrob

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.
 
Top