Cascading Combo Box Help

Hello-
I am a new user and struggling with creating cascading combo boxes or dropdown boxes. (I would rather have combo boxes because the drop down arrow is always visible) I have gotten the dropdown to work somewhat, but I fear that dropdown boxes do not work with numerical values? Is there any way around this?

With that said, I am completely lost using active X combo boxes. Can anyone take a look at this and help?

Thanks-

Mike

Hello there,

Select the CUI worksheet, then right click on the worksheet's tab. In the blank space provided, next to the cursor copy and paste the following code:

Please Login or Register  to view this content.

Close out of Visual Basic. Make sure the Design mode button is not clicked under the developer tab and then click on cells E18

Thank you so much for writing this code for me. It is very generous. I am still having difficulties however, I'm sure the problem is in the interface between the keyboard and the seat.

I have attached an updated spreadsheet. I am trying to get the first selection of Units to drive the slections of diameter and length. For example, if metric is selected, I want the selections of diameter and length to consist of only metric options.

How do I do this?

Once again, Thank you.

Mike

Hello there,

It's okay it gets confusing. The code is based on one activex combobox being on the worksheet with the name combobox1. When you click cell D18, E18, F18, and G18 the combobox shows and the row source is automatically updated to the range of cells in the Lists worksheet that correspond with the selected column. Attached is your original worksheet corrected so that it will work properly. To see the worksheet work, make sure to enable macro and then select a cell in the range D18:G18.

Thanks again....

When I select inch in the units dropdown, it should give me a list of diameters in inches...such as 9'-6", 11'-6" and 13'6" for example. The diameters and lengths are always in meters. How do I correct this.

Sorry if I'm making this more difficult than it needs to be.

Mike

Change the following line of code:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Please take the time to read the code, anything that appears in green is a comment meant to help you understand what each line of code is doing. These comments should help you adjust the code to meet your needs. To view the code, Press Alt+F11.

Thanks!

*If this solves your post please mark this thread solved and maybe give a little star tap if I was able to help.