Combo boxes and VBA

[bjorgen]

Is there a way to get a userform's combo box values and store them in a variable?

For my particular project I'm using pivot table fields to filter a pivot table and running through each pivot item in the field to test if that entry is relevant, if so show it in the drop down. IE customer filter above a product filter, if the customer has ordered a particular product show that product in the combo box, if not don't.

My problem here is that for big lists this takes a long time. One pivot field always starts with the customer's name and then has other parameters. I'd like to take the customer's name and store that and then only test the pivot items starting with that name. Also, i'd like to be able to do this for more than one customer and test against all selected names.

Any ideas here? I greatly appreciate it.

 

[bensonsearch]

hi,
sure is.

dim asd as string

asd = combobox1.value

msgbox(asd)

 

[bjorgen]

bensonsearch, thank you!

I actually got the information at a different point, capturing it when the combobox was populated. I had trouble capturing the data as an array using the combobox.value when there were multiple combobox items.

 

[bensonsearch]

you could put the code under the combobox change event then it would capture every time the value was changed.

 

[bjorgen]

I was able to capture the input in a specific combo box no problem. The issue was that I needed to capture all of the possible options from a combobox, not just one.

To do that, upon populating the combobox (based on some criteria) I did .additem and at the same time (so based on the same criteria) added it to a 1 dimensional array. Does that make sense?

 

[bensonsearch]

certainly does