Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi All,

I have a workbook with 2 sheets. On sheet 1 I have two lists:

List1:
Column A Column B
ProjectID ProjectName

List2:
Column D Column E Column F
ProjectID SubProjectID SubProjectName

On sheet 2, I have 2 combo boxes. what I want to do is fill the first
combobox with the contents of list 1. the second combobox will be filled
based on the selection in the first combobox (ProjectID).

Can someone provide me with a few hints or code snippets? I think I'm
looking for code to go into the combobox1 change event.

TIA
Lee