combo box codes

  • Thread starter Thread starter thrava
  • Start date Start date
T

thrava

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"
 
Back
Top