See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Varney" wrote in message
...
Hi, I have a problem I need help with. I will attempt to explain what I
am
trying to do. I have created a drop down box with several customer's
names
to choose from. Each customer has different "unit" numbers to choose
from.
What I am wanting to do is when I select a customer, I want the next drop
down list to show only that customer's "units". Basically, I want two
drop
down lists beside each other. When I select a customer, then that
customer's
units are shown. When I select a different customer in the first box,
then
the unit numbers change to the customer they are assigned to. As I stated
before, I know how to make a the drop box listing the customers, so I do
not
need help making the drop boxes.

Thank you in advance for your help!