Is there a way to populate a userform comboBox with Pivot table fields? I have a "Department" field in the pivot table that is not constant and would like to have the combo box reflect the changes. Thank you
Is there a way to populate a userform comboBox with Pivot table fields? I have a "Department" field in the pivot table that is not constant and would like to have the combo box reflect the changes. Thank you
Hi
You could probably fill the combobox from the pivot field every time the form loads. Can you attach an example file with some representative data, a form with combobox, the pivot table, and explain why the field is not "constant"? Is it because of changes to other pivot selections? Or changes in data?
rylo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks