Forcing an entry

melamaric · Apr 2nd, 2002, 08:50 AM

I have to send out a template to 160 different managers, and I need them to fill in their particular entity's unique number, which in turn will force other cells within the workbook to return a value (i.e., name of entity and location using VLOOKUP). The problem is that sometimes the managers do not read the instructions or forget to fill in the requisite areas of the workbook. Is there a way that I can force them to fill in a certain cell such that a pop-up window will appear to indicate they haven't filled in enough information or even closing the file will trigger an error message?

Ivan F Moala · Apr 2nd, 2002, 11:09 PM

Quote:

On 2002-04-02 07:50, melamaric wrote:
I have to send out a template to 160 different managers, and I need them to fill in their particular entity's unique number, which in turn will force other cells within the workbook to return a value (i.e., name of entity and location using VLOOKUP). The problem is that sometimes the managers do not read the instructions or forget to fill in the requisite areas of the workbook. Is there a way that I can force them to fill in a certain cell such that a pop-up window will appear to indicate they haven't filled in enough information or even closing the file will trigger an error message?

You will have to use VBA code to do his.
If interestd then post the criteria;
eg. What cells MUST be filled in

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:50 AM	#1
melamaric Board Regular Join Date: Mar 2002 Location: Ontario, Canada Posts: 68	I have to send out a template to 160 different managers, and I need them to fill in their particular entity's unique number, which in turn will force other cells within the workbook to return a value (i.e., name of entity and location using VLOOKUP). The problem is that sometimes the managers do not read the instructions or forget to fill in the requisite areas of the workbook. Is there a way that I can force them to fill in a certain cell such that a pop-up window will appear to indicate they haven't filled in enough information or even closing the file will trigger an error message?