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

Use the click event of the combobox.

--
regards,
Tom Ogilvy

thrava wrote in message
...
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

Hi Tom,
Can you explain a bit more please.
I'm a novice at this.
Thanks


-----Original Message-----
Use the click event of the combobox.

--
regards,
Tom Ogilvy

thrava wrote in
message
...
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


.

If the combobox is from the control toolbox toolbar, leave the sheet in
design mode and double click on the control

This should put you in the click event. This fires when a selection is
made.

If it is from the forms toolbar, the right click on the control and select
assign macro. The assigned macro will run when a selection is made.

If it is a dropdown using data validation with the list option, then you can
use the change event in xl2000 and later. This is the normal sheet change
event.

If you don't know about events, look at
http://www.cpearson.com/excel/events.htm


Basic information about activeX control from the MSForms 2.0 library
(control toolbox toolbar controls)
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

--
regards,
Tom Ogilvy


thrava wrote in message
...
Hi Tom,
Can you explain a bit more please.
I'm a novice at this.
Thanks


-----Original Message-----
Use the click event of the combobox.

--
regards,
Tom Ogilvy

thrava wrote in
message
...
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


.