Combo Box Values

[johnbird1988]

Hello,

I have a activex combo box and would like to populate the values with the value in a pivot table.

I have tryed the below code but nothing happens am I doing something wrong or can this not be done?

Private Sub ComboBox1_DropButt*******()
ComboBox1.ListFillRange = ActiveSheet.PivotTables("PivotTable15").PivotFields("ADVISOR").Value
End Sub

Thank you

John