R
Robert Crandal
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 my form with 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 of form: " & 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??? I can't think of anything else.
thank you!
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 my form with 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 of form: " & 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??? I can't think of anything else.
thank you!