VBA - TextBox output from multiple ComboBoxes

[VbWriter13]

Hello All,

I'm designing a UserForm that allows the user to make selections from multiple ComboBoxes in order to yield the desired output.

For Example: Select the height, weight, color, age, gender, and occupation from separate ComboBoxes and the output would be the persons name in a TextBox.

There curently 250 entries(lines), each with 6 characteristic(columns).
The tricky part is that each characteristic is dependent on the previous.

Is there a way I can use my current spreadsheet to do this?

Thanks in Advance,

VBW13

 

[Greg Truby]

This is rather complex to pull off in code. Furthermore Excel has some built-in functionality that would essentially do the same. I would suggest simply using Custom Views to hide/unhide the columns you don't care about and then use Filter (aka AutoFilter in Excel 2003 & below) and see if that, plus a smidgeon of user training or some simple instruction materials would do the trick before I'd invest beaucoup hours in coding up a userform-based solution.