Link to home
Start Free TrialLog in
Avatar of ammo12kmf
ammo12kmf

asked on

Excel VBA UserForm file keeps crashing - RunTime Error 75

Hello, I'm a little stuck! I am using Excel 2007 with a bit of VBA and have been dabbling in the wonderful world of User Forms. For some reason, if I open any worksheet which uses User Forms it seems to crash if it is left untouched for any period of time longer than about 2 minutes - often generating a Run Time error 75. I've tried re-installing Microsoft Office, but that doesn't seem to help. And I'm fairly certain the file (and code) is fine because I've tried the same file on other computers and it runs perfectly.

I don't know anything about improving performance, registry fixing or defragmenting, but from what I can gather, it might be something to do with that? If so, how do I go about sorting the problem so my Excel file doesn't keep crashing?

Thanks in advance for any advice people can offer.
Avatar of kacor
kacor
Flag of Hungary image

Maybe you met a bug try on the Microsoft forum ...

:-( Janos
75 Path/File access error - check the evtl path/filename
Avatar of ammo12kmf
ammo12kmf

ASKER

Sorry, what's the evtl file/pathname? Please bear in mind I'm completely ignorant about these things!
75 is  Path/File access error - check the possible path/filename(s)
sorry for my mistake
Janos
ASKER CERTIFIED SOLUTION
Avatar of EDDYKT
EDDYKT
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial