Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform problem with "Run Time Error 75"
Hi Robert,
I started having similar problems quite recently (Run Time Error 75" ("Could Not Find The Specified Object"), seems to happen sporadically when vba is trying to reference a form - doesn't seem to limited to one particular form. I have a vague (very) notion that there is an "orphaned" form object, caused by halting the code during development. Also, whenever this happens, Excel will crash if I try to save the application. This has been happening with increasing frequency, and is quite frustrating. I'm running Winsows XP SP3 and XL2007. I'm just wondering if you've found the cause/solution to this yet. regards, Dave On Dec 28 2009, 11:33*pm, "Robert Crandal" wrote: This is follow-up related to my posting here on 12/19/09 regarding "Run Time Error 75" ("Could Not Find The Specified Object". Basically, my Userform1 is "disappearing" from my workbook for some unknown reason, even if my workbook is untouched for any period of time longer than 2 minutes. *If I come back to my computer after 2 minutes, I will try to load myformwith this code: * (which causes RT-Error 75) * * * * * * * * *UserForm1.Show vbModeless * I also get an Error 75 message if I try to run the following code: * * * * * MsgBox "Name ofform: " & UserForm1.Name Then, if I try to view my UserForm1 object in my VBAProject view window, I get an error that says "Path/File sccess Error". Does anybody have any theories why I cannot suddenly use Userform1 in my workbook, especially if my code is not very complicated at all?? * All I do is handle UserForm1_Initialize() and Worksheet_Change() and all my code does is transfer data from userform to spreadsheet and vice versa with very very very basic VBA code. *I even set "Application.EnableEvents" to false and true inside my Worksheet_change() function. Could this be just an operating system issues?? *(I noticed that this problem only occurs while using Excel 2007 (Trial Version) on Windows XP Professional SP2. *I never get this error on Windows Vista using Excel 2007) Might this problem just be related to a bad or bugged version of Windows XP, Service Pack 2??? * Ican'tthink of anything else. thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform problem with "Run Time Error 75" | Excel Programming | |||
Help with userform problem: error message "obj doesn't support thisproperty or method" | Excel Programming | |||
Userform problem with "obj doesn't support this property or method"error message. | Excel Programming | |||
how do I correct a "run time error 1004-unable to open" problem? | Excel Programming | |||
"Can't Show Modally" - Run-Time Error '400' Problem | Excel Programming |