Hi, I have some userforms that contain a listbox, the userform opens with the listbox and I receive error: "the object invoked has disconnected from its clients"
pressing debug the highlighted statement is UserFormx.Show.
In the Sub UserForm_Initialize() I've included: Me.ListBox1.RowSource = "Lists!L2:L24" but this doesn't help, the list is also a Named list and the RowSource property is =NamedListName
This problem seems to appear more on clients pcs then it does on my pc. Can anyone suggest a solution?
pressing debug the highlighted statement is UserFormx.Show.
In the Sub UserForm_Initialize() I've included: Me.ListBox1.RowSource = "Lists!L2:L24" but this doesn't help, the list is also a Named list and the RowSource property is =NamedListName
This problem seems to appear more on clients pcs then it does on my pc. Can anyone suggest a solution?
Last edited: