software

I am setting up an order form template for a customer of the company I work
for and need help. I have the template secured where they can only enter data
into specific cells and I am using the Validation function to stop incorrect
information from being entered. But I need a way that if they don't enter
anything, the template will NOT allow them to proceed to the ordering area
until they enter the correct information in these few cells. The cells are
for quot;Order Datequot; and quot;PO Numberquot;. Without this information, we can't process
the order.

Hi!

Just some thoughts:

You can probably do what you want but it will take VBA code to accomplish. I
can't help with that but consider this:

The person that fills out the ordering info might not be the same person
that assigns a PO number. I know this from my own experience. I would fill
in the order info and forward the requisition to the purchasing dept where
the PO number would be assigned and the order was actually executed. So, if
you limit data entry the way you have described it may not be the best
practice.

Have you considered a big bold message in a big bordered box that says:
quot;Without an Order date or PO number we cannot process this orderquot;

Biff

quot;Mike Jquot; lt;Mike gt; wrote in message
...
gt;I am setting up an order form template for a customer of the company I work
gt; for and need help. I have the template secured where they can only enter
gt; data
gt; into specific cells and I am using the Validation function to stop
gt; incorrect
gt; information from being entered. But I need a way that if they don't enter
gt; anything, the template will NOT allow them to proceed to the ordering area
gt; until they enter the correct information in these few cells. The cells are
gt; for quot;Order Datequot; and quot;PO Numberquot;. Without this information, we can't
gt; process
gt; the order.