I think this might be a good place to start:
http://www.contextures.com/xlDataVal02.html
Check dependent dropdown lists

Does that help?

***********
Regards,
Ron


"Adam Kroger @hotmail.com" wrote:

I have a cell in my workbook that I would like to have filled from a
dropdown list. The possible option number about 30 so a "Data Validation"
would be unwieldly unless I could nest it, as the possibilities fall into 3
to 4 catagories. Is there a way to do this? I thought about a combo box,
but I want the same dropdown to be usable by approx. 120 cells. Is there a
macro that could be done in wich I select the cell and then a pop-up window
will allow the fill, or some way around this?

I am using Excel 97.