+ Reply to Thread
Results 1 to 6 of 6

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

Hybrid View

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    shrewsbury
    MS-Off Ver
    Excel 2003
    Posts
    25

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

    Hi I keep getting an error after placing this vba into a userform to basically stop popel inputting info into a userform unless they specify the number they require. Anybody got any solutions or is there a better way. Also when I debug it points to the vba which calls the userform. Thanks in advance.

    Private Sub MultiPage1_enter()
    MultiPage1.Pages(0).Enabled = False
    MultiPage1.Pages(1).Enabled = False
    MultiPage1.Pages(2).Enabled = False
    MultiPage1.Pages(3).Enabled = False
    MultiPage1.Pages(4).Enabled = False
    If ComboBox1 = "1" Then
    MultiPage1.Pages(0).Enabled = True
    MultiPage1.Value = 0
    ElseIf ComboBox1 = "2" Then
    MultiPage1.Pages(0).Enabled = True
    MultiPage1.Pages(1).Enabled = True
    MultiPage1.Value = 0
    ElseIf ComboBox1 = "3" Then
    MultiPage1.Pages(0).Enabled = True
    MultiPage1.Pages(1).Enabled = True
    MultiPage1.Pages(2).Enabled = True
    MultiPage1.Value = 0
    ElseIf ComboBox1 = "4" Then
    MultiPage1.Pages(0).Enabled = True
    MultiPage1.Pages(1).Enabled = True
    MultiPage1.Pages(2).Enabled = True
    MultiPage1.Pages(3).Enabled = True
    MultiPage1.Value = 0
    ElseIf ComboBox1 = "5" Then
    MultiPage1.Pages(0).Enabled = True
    MultiPage1.Pages(1).Enabled = True
    MultiPage1.Pages(2).Enabled = True
    MultiPage1.Pages(3).Enabled = True
    MultiPage1.Pages(4).Enabled = True
    MultiPage1.Value = 0
    End If
    End Sub

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

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

    What other code do you have in the userform?

    When you run the form from the VBA editor (F5) which line is highlighted when you get the error and debug?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    10-29-2012
    Location
    shrewsbury
    MS-Off Ver
    Excel 2003
    Posts
    25

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

    I have a multitude of code which has been built over 6 weeks so would be pretty difficult to show you in debug the below code is highlighted
    Sub multi()
    UserForm13.Show
    End Sub
    this seems slightly strange to me

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

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

    Did you open the form in design view and run it with F5/F8?

    If you do then the ' real' line of code the error occurs on should be highlighted when you click Debug.

    If that doesn't happen goto Tools > Options ... and on the General tab check either Break on all Errors or Break in Class Modules.

    Then try opening the form.

  5. #5
    Registered User
    Join Date
    10-29-2012
    Location
    shrewsbury
    MS-Off Ver
    Excel 2003
    Posts
    25

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

    the line userform13.show is highlihted

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

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

    That line isn't what's causing the error.

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error: The Object Invoked Has Disconnected from Its Clients
    By ks1102 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2013, 02:28 AM
  2. Replies: 0
    Last Post: 05-23-2013, 09:12 AM
  3. "The object invoked has disconnected from its clients"
    By ianpwilliams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2013, 01:01 PM
  4. error: the object invoked has disconnected from its clients
    By cooper1308 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2009, 10:59 AM
  5. Automation Error: "The object invoked has disconnected from its clients"
    By cartman44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2009, 04:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1