LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Userform errors

I have a project that contains a number of forms and when i try to
show the last one in normal run mode i get the error:

run-time error ‘-2147417848 (80010108)

Automation error
The object invoked has disconnected from its clients


Originally it also locked out the keyboard also. I used the appspro
project cleaner like someone else was told for a similar problem and
now it doesnt lock out the keyboard but the form wont show. If i try
to just show the form in a different sub i get the 424 object required
error (i think its 424). The other forms in the project will show
during normal running but get the 424 error trying to run them on
their own. The other advice they received was to rebuild it in a new
book. Does this mean from scratch like i have to retype the main code?
or can i copy and paste the code to say word reuse it and just rebuild
the forms from scratch?

Also as i have messed with this i noticed somthing strange. I have a
module where i keep useful code snippets to copy instead of having to
retype them everytime and i also keep basic forms that i can just
import and rename for the same purpose. Those forms were giving me the
same 424 error when i tested them after the main project. I wondered
if maybe they were "broken" since i made the project forms from them.
So I closed excel (it locked up doing so had to ctrl alt delete out)
and then the basic forms worked fine when i reopend and tried again. I
would appreciate any input on this matter thank you


john
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) Corey Excel Programming 2 January 9th 07 01:01 PM
Excel Throwing Circular Errors When No Errors Exist MDW Excel Worksheet Functions 1 August 10th 06 02:15 PM
Loading Userform Errors 1004 Steven Cheng Excel Programming 4 April 5th 06 04:58 AM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Unresolved Errors in IF Statements - Errors do not show in results Markthepain Excel Worksheet Functions 2 December 3rd 04 08:49 AM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"