Did you download the sample file? It might help you see how the order
form works.

In Excel 2007, for step 8, click OK, to close the dialog box.
Then, on the Ribbon, click the Formulas tab, and click Define Name.
Create the next name, CustLookup, as described in the instructions.

After you create the CustList name, you should be able to use it in the
data validation dialog Source box: =CustList

Candyman wrote:
I followed the links and downloaded the sample files, tried to recreate them
as written and grounded out when I tried to add a customer list. I failed to
mention I was using XL2007 and step 8 stumps me, can't figure out how to
click add.

Further down in create customer dropdown and lookup, step 4, custList was
not available as a source. Thats where I am, could use further direction.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html