"Object invoked disconneted from its clients"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet Activate event not firing 4
userform: object required 1
Object invoked disconnected from its clients. 1
Determine if Carriage Return or Tab key is used 1
Move a single combo box from one cell to another... 3
Active Workbook from User Form 1
Validation List 7
Resetting ListBox1.ListIndex to -1 after user selection 20

Back
Top