Sub Fires on Worksheet Close

I am working on a worksheet in which I have an activex combo box. I have a sub (UpdatePrice) that gets called when the change event fires on the combo box. All works well. My question is when I close the workbook, the sub UpdatePrice fires again.

Anyone have a reason for this?

Thanks,
Lee

Code (located in VBA - Sheet1):

Please Login or Register  to view this content.

Hello germ,

OLE object events are handled by the container object. In this case, the container is the worksheet. The container is also responsible for issuing system messages to the object. When the workbook closes all objects are notified starting at the bottom and working up. The OLE objects are notified first, then the worksheets, etc. on up to the application object, Excel itself. Once the ComboBox closes, the text is cleared. Because the worksheet is still open it process the ComboBox_Change event. The worksheet can not close until the modal dialog box is answered.

Hi germ
I've had this same issue in the past. Try the code in the attached. It's got something to do with m_blnupdating. I'm not schooled enough in VBA to explain it to you. Perhaps someone viewing your thread can explain it to both of us in plain English
Hope this helps.
John

John,

That code worked perfectly - Thanks!

One issue - I added a listbox and tried the same code and it did not work. Does something need to change a bit?
(I've attached an example)

Thanks,
Lee

Hi Lee
If you change your list box property from Multi Line to Single Line the workbook closes without firing the macro. Why? I'll need to spend some time on that.
John