Hi Friends,
I have a User form with a comboBox caled "cmbpivotvalue" . When i press Submit/validate button "cmbValidate" in the userform , the values in this comboBox should go to the "VALUES" section on the PivotChartFields (please refer the screenshot) .
Please help me to create code for this.
Thanks in Advance.

I have a User form with a comboBox caled "cmbpivotvalue" . When i press Submit/validate button "cmbValidate" in the userform , the values in this comboBox should go to the "VALUES" section on the PivotChartFields (please refer the screenshot) .
Please help me to create code for this.
Thanks in Advance.