Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Forcing an entry

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Ontario, Canada
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •