See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"snarled times" <snarled wrote in message
...
I would appreciate any help.
Have workbook of several pages - have 2 information coloums that are used
in
many segments of the worksheets - (tracking ad spots that air on certain
stations and times)
that I would llike to create 2 different drop down boxes for (1) time (2)
spot# -
can I create 2 drop down list - one TIME, one SPOT# so when I right click
on
the cell I can select either and get that drop down menu so I can apply to
any cell?
so if I click on TIME - I will get the list of time or Sport and get the
list of spot #'s - I am not VB experienced and want to keep it simple
thanks in advance