List Box selection based on combo box selection

[MFA]

Hi all,

I have a combo box and a list box. Im wondering if it is possible for the selection in my list box to be made based on what is selected in the combo box.

For example, the combo box has a list :
Architectural
Mechanical
Electrical

The list box has a list:
Architectural
Geomatics
Site
Electrical
Mechanical
Structural

If Architectural is selected in the combo box, I want the selection in the list box to be forced to be architectural.

Thank you for your help.

[[email protected]]

I had the same question. Yes, you can. There are a few different ways, but the easiest is by suing the INDIRECT function.

See this link for instructions...

http://www.contextures.com/xlDataVal02.html

[MFA]

Thanks, but thats not exactly what im trying to do.

I can't use data validation...it has to be a combo box and a list or two combo boxes. What i need is for the selection in the first combo box to force the selection in the second. That is, the user will be allowed to select the first choice, but not the second. The second choice will be the same as the first, just in a different combo/list box.

Im not sure if that makes sense...or if it is possible...

[royUK]

What kind of Controls are you using? Forms ToolBar, Controls ToolBox or UserForm.?

Where are they populated from?

[MFA]

Im using the control tool box. The first combo box is populated based on a selection in a previous combo box. The second (list box) is populated from a named range on Sheet 3 ("PickList") from cells C11:D66 ("SubCategoryPickList").