Building Comboboxes that act like Data Validation Lists

[aaanenson]

Hi - This is in reference to post: http://www.excelforum.com/excel-prog...81#post2941281


I am a bit new to VBA but have some background in programming so I think I can get this solution to work for me as well. The only problem I have here is that I need the combobox to look and act just like it would if it was a data validation list. The content of what is selected in the combobox is used by several functions throughout the workbook. How do I use this this solution given my situation?

[Tinbendr]

You don't give enough information to allow us to be helpful.

How do I use this this solution given my situation?

If you're referring to ANS #6, the combobox #2 will be filled automatically when combobox1 is selected. After the selection is made in combobx2, the control name, in this case "combobox2", will hold the value of the selection. (Or combobox2.Value as Value is the default.)