I have a macro (Excel 2003) which refreshes a pivot table based upon the value in a cell. This macro runs perfectly on its own.
Now I want to use a comboBox change event to call my macro when a user selects a different value from a list.
I've created a combo box and linked it to a list of values (ListFillRange) for the drop down. The combo box is linked to a cell (LinkedCell) which is referenced by the macro. I'm using the following code for the comboBox change event to call my macro ("RefreshPivot").
When I choose a different item in the combo box, the macro starts to run but fails on the first line of the macro. Since the macro runs perfectly independent of the combo box, I'm thinking my code for the comboBox change event must be wrong. Can anyone tell me if my code should work or help set me straight if I'm doing this incorrectly?
Thanks!!!!!!!!
Bookmarks