Userform: "The object invoked has disconnected from its clients" (error message)

**scoclu** · 01-08-2018, 10:58 PM

Hello All,
Starting to be discouraged by this error message: "The object invoked has disconnected from its clients".
Is anyone can help me find where are the errors, please?
Many thanks for your time & help!

**Norie** · 01-08-2018, 11:12 PM

When do you get the error?

**scoclu** · 01-08-2018, 11:32 PM

I have this error when I click on the "ShowUserform" button in Xls, then "Choix de couleur" right button, this error message appears and Xls crashes...
Thanks!

**Doc.AElstein** · 01-09-2018, 11:40 AM

Hi,
I got your PM asking for help…, but do not really have too much experience with UserForms, especially with large and complicated ones like yours..

I could easily see one error after hitting “"Choix de couleur" by selecting Debug option after the error occurred, and then in the VB Editor I hovered over the error place and found this
: Screenshot: https://imgur.com/lnmKcXH
Errorscoclu251x141 32_8KB.JPG

This mod will prevent that error by removing the offending “$” in “1.00 $”

Please Login or Register  to view this content.

But if the issue is any more complicated then I think it is beyond my confidence..

Alan

**snb** · 01-09-2018, 12:15 PM

On n'a pas besoin d 'Initiliaze' que pour remplir des combobxes et les Listboxes.
Quand on utilise checkboxes 1 seul par choix suffit.
Tu peux jeter les checkboxes completeoui1 ... completeoui6 dans la poubelle.
J'ai changé les noms des checkboxe CompleteNoN1 ... completenon6 au C_01 ... C_09.

Delete all code in Userform_ Initialize.
You should enter the default properties of controls in design mode.
Please remove worksheets 'Download1' & 'download3';

**scoclu** · 01-09-2018, 12:30 PM

Thanks so much Norie & Alan & Snb for your help with this file!
Alan I made the change you recommended, but I still have this:

Capture.PNG

Can you please help again?
Thanks a lot,

**scoclu** · 01-09-2018, 12:49 PM

Hello Snb, and thanks for your advice!
Could you please be more specific? I have an issue with Private Sub UserForm_Initialize()
But how to replace these codes?

Many thanks!

**Doc.AElstein** · 01-09-2018, 01:30 PM

Sorry I can't help any more, it is way out of my depth
Alan

Edit: thanks for the rep thingy

**scoclu** · 01-09-2018, 02:36 PM

Thanks Alan for your help, appreciated!

**scoclu** · 01-09-2018, 02:52 PM

Sorry it seams like there is an issue with this code:

Capture1.PNG

HTML Code:

Someone knows how to correct this?
Big thanks!

**snb** · 01-09-2018, 03:33 PM

D' abord (le 'format' est un besoin d'apres); essayez:

Please Login or Register  to view this content.

**scoclu** · 01-09-2018, 04:04 PM

Thanks Snb, but by doing so, we are loosing the format and $ sign:

Capture2.PNG

should be:

Capture3.PNG

This code below was working... so why a debug is needed?

Please Login or Register  to view this content.

Many thanks!

**snb** · 01-09-2018, 04:19 PM

You indicated in
https://www.excelforum.com/excel-pro...ml#post4817453
that this codeline gave an error !

Please Login or Register  to view this content.

**scoclu** · 01-09-2018, 04:37 PM

Thanks Snb! Sorry I still have a Compile error: Variable not defined...
Please, did you add something else?

Also, I followed your recommendations for the Userform_Initialize, trying to remove everything.
How to adjust these codes? Where should they go?

HTML Code:

Many thanks!

**snb** · 01-09-2018, 04:56 PM

Sorry I still have a Compile error: Variable not defined...

Remove 'Option Explicit' everywhere you find it.

**Norie** · 01-09-2018, 05:24 PM

What's highlighted when you get the error 'Compile error: Variable not defined'?

Can you upload the workbook as it is now?

**scoclu** · 01-09-2018, 05:45 PM

Many thanks Snb & Norie for your help,
I follow you Snb: I removed all "Option Explicit"... but have a Run-time error "424" Object required...
Here is the last version.
Any idea?
Thanks!

**Norie** · 01-09-2018, 06:13 PM

Sounds like you don't have a textbox with the name Texbox3768.

Should it actually be TextBox3768?

By the way, instead of using textboxname (or whatever) to get the value in the textbox try getting it explicitly using textboxname.Value

For example.

Please Login or Register  to view this content.

PS You might also want to consider using more descriptive names for the controls on the form.

**scoclu** · 01-09-2018, 06:52 PM

Many thanks Norie for your adjustment & recommendations.
I have made these changes but I have still the debugger on Private Sub UserForm_Initialize() and Private Sub TextBox3768_Change()
Any idea?
Big thanks!

**Norie** · 01-09-2018, 07:07 PM

What error are you getting and under what circumstances do you get it?

**scoclu** · 01-09-2018, 07:46 PM

Hello Norie,
I have the same error message as this morning: "The object invoked has disconnected from its clients"
when I click on the "ShowUserform" button in Xls, then "Choix de couleur" (right button), this error message appears and Xls crashes...
Thanks a lot,

Userform: "The object invoked has disconnected from its clients" (error message)

LinkBack

Thread Tools

Rate This Thread

Display

Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Userform: (error message) ??????........Don't PM and ask me unless it is simple... !!

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: (error message) ??????........Don't PM and ask me unless it is simple... !!

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Re: Userform: "The object invoked has disconnected from its clients" (error message)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Error: "The object invoked has disconnected from its clients"

"Automation error: The object invoked has disconnected from its clients"

Recieving the error "the object invoked has disconnected from its clients"

Excel freezes or "automation error: The object invoked has disconnected from its clients"

"The object invoked has disconnected from its clients"

Error Message : The object invoked has disconnected from its clients. Need help in VBA

Automation Error: "The object invoked has disconnected from its clients"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions