I have several combo boxes that are used to feed diffirent
revenue scenarios.

These scenarios are used by a PivotTable. I want to have
the pivot table refresh automatically everytime a user
clicks and or chooses a value from any of the pull-down
menues from combo-boxes.

What I have now is:
Private Sub Worksheet_selectionChange(ByVal Target As
Range)
ActiveSheet.PivotTables
("PivotTable2").RefreshTable
End Sub
but this only works if the user clicks on a worksheet cell
after wards.
Any help?
Thanks
Thrava