Value Dependent Dynamic Range ComboBox in Userform

Hello All,

I am rather stumped. I am making a user-form that in the end generates a chart from the data in the workbook. Since it is to be something the user can set up so they get the chart they want, it requires some comboboxs that will filter what data the chart will show.

There's a top level combobox, then another one underneath that changes its contents according to the value selected in the top one. I've gone through what must have been a dozen or so threads, but none seem to quite get the results I want. Lately I am getting the error 13 type mismatch, among others I have had in the past. Unfortunately the debugger doesn't highlight the offending line, so I have to try and guess.

Please Login or Register  to view this content.

The little text pieces are just "switched off" code until I get to grips with the first problem.

Any help will be greatly thanked.

Regards

Hello Arkadi,

Thank you for the very quick response. Attached is the workbook. The VBA code for the userform is a bit messy, working progress.

Regards

Hi Norie,

Thank you very much. Worked like a charm. Seems obvious now looking at it. Couldn't see the wood for the trees.

Regards

Hi Arkadi,

Thank you and no worries about the delay. I had forgotten about marking it solved, so thank you for reminding me.

Have a nice day.

Regards