Macros and Combo Box

[pony08]

I would like to have a macro run when I click off of a combo box. The combo box has dates by Quarter and the macro refreshes a pivot table. The pivot table is filtered by the combo box quarter selection.

 

[pbaldy]

You can put the macro in the after update event of the combo.

 

[pony08]

How do I modify the after update event?

 

[pbaldy]

Well, you can find it here:

http://www.baldyweb.com/FirstVBA.htm

but instead of [Event Procedure] you'd put the name of your macro.

 

[pony08]

Excellent....Thanks!

 

[pbaldy]

Happy to help!