Thread: How Do I call a Macro Using the ComboBox Change Event?

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").

Sub Combobox1_Change()
             RefreshPivot
End Sub

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!!!!!!!!

I'm not sure what sort of a response, if any, you are likely to get based on the limited information you have provided.

A sample workbook with some typical data and the code is the best way to get assistance.

Regards