Use ComboBox to Populate List Box

[DJ'sGiGi]

I have created a ComboBox with six items that have 3 related pieces of data. I'd like to automatically populate a list box based on the user's ComboBox selection. For instance, if "Children" is selected, then the following should appear in the list box:
1. Graduation rates
2. Youth crime
3. Childhood Obesity

I have named all pieces of data (e.g. the list above is called CF_OM). Can this be done with a formula or "SIMPLE" VBA code?

 

[BrianExcel]

Yes this can be done.

here is a file I posted that accomplishes it. The code is there as well.

http://www.box.net/files#/files/0/f/0/1/f_665308741

 

[DJ'sGiGi]

It appears that boxnet requires an account outside of Mr.Excel. Is that correct?

 

[BrianExcel]

I don't think it requires an account..you just have to go download the file. The advantage of sites like box.net and others though is that most of them check for viruses when you upload/download...makes it safer.