ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Object invoked disconneted from its clients" (https://www.excelbanter.com/excel-programming/373861-object-invoked-disconneted-its-clients.html)

GlenC

"Object invoked disconneted from its clients"
 
I have validation procedure in a selectionchange event that when activated
causes a Comboboxchange event which in turn causes a Selectionchange event
and I get the subject error , when the validation procedure runs again. What
I want to do is resume the selection change event where I left off, Not start
a new one.

Any one have suggestions?
--
Glen

Doug Glancy

"Object invoked disconneted from its clients"
 
GlenC,

Have you tried using Application.EnableEvents to turn events on and off? I
can't tell if you want the Combo change event to fire or not, but if you
don't it sounds like you could just set Application.EnableEvents = False at
the start of your SelectionChange event code and back to True at the end of
it.

hth,

Doug


"GlenC" wrote in message
...
I have validation procedure in a selectionchange event that when activated
causes a Comboboxchange event which in turn causes a Selectionchange event
and I get the subject error , when the validation procedure runs again.
What
I want to do is resume the selection change event where I left off, Not
start
a new one.

Any one have suggestions?
--
Glen





All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com