| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Making cells compulsary to fill in on a worksheet
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!!!! |
|
#2
|
|||
|
|||
|
J.E. McGimpsey posted some code to do just what you're
asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . |
|
#3
|
|||
|
|||
|
I don't understand the instructions! Sorry to bother you. Can you help?
"Jason Morin" wrote: J.E. McGimpsey posted some code to do just what you're asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . |
|
#4
|
|||
|
|||
|
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. -----Original Message----- I don't understand the instructions! Sorry to bother you. Can you help? "Jason Morin" wrote: J.E. McGimpsey posted some code to do just what you're asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . . |
|
#5
|
|||
|
|||
|
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" wrote: 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. -----Original Message----- I don't understand the instructions! Sorry to bother you. Can you help? "Jason Morin" wrote: J.E. McGimpsey posted some code to do just what you're asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . . |
|
#6
|
|||
|
|||
|
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 -----Original Message----- 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" wrote: 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. -----Original Message----- I don't understand the instructions! Sorry to bother you. Can you help? "Jason Morin" wrote: J.E. McGimpsey posted some code to do just what you're asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . . . |
|
#7
|
|||
|
|||
|
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. "Jason Morin" wrote: 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 -----Original Message----- 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" wrote: 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. -----Original Message----- I don't understand the instructions! Sorry to bother you. Can you help? "Jason Morin" wrote: J.E. McGimpsey posted some code to do just what you're asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . . . |
|
#8
|
|||
|
|||
|
Post what you've tried so far. It maybe easier to correct that way.
abfabrob wrote: 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. "Jason Morin" wrote: 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 -----Original Message----- 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" wrote: 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. -----Original Message----- I don't understand the instructions! Sorry to bother you. Can you help? "Jason Morin" wrote: J.E. McGimpsey posted some code to do just what you're asking: http://tinyurl.com/3kaos HTH Jason Atlanta, GA -----Original Message----- 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!!!! . . . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need ability to leave certain cells of an worksheet editable. | Excel Discussion (Misc queries) | |||
| Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
Linear Mode
