UserForm Causes Crash Upon Load/Show

[fireflyon]

i have a user form which is activated by a button. when this button is clicked excel crashs every now and then. i get an error message run time error 75, could not find object. it asks me to debug or end. whatever option i choose when i try to save the worksheet there after excel crashs and closes. any body else have this problem, what could be the cause?

[Ger Plante]

Thats weird...

According to MS a RunTime error 75, is a "Path/File access error"

You really to find the line of code it is failing on by clicking on Debug when it crashes.

Alternatively, step through your code using F8.

Are you using new controls on the form from a non-standard library?

Are you accessing a file in remote location which might suddenly not become available, or a file that might become read only. Are you loading inamges from a location... basically anything that is being read, or pulled in from a local hard disk or networked location...?

HTH
Ger

[Dave Hawley]

Could be any one of 1000 reasons.

[norie]

Goto Tools>Options... and on the General tab check Break on All Errors.

Now when the code fails and you hit debug you should be taken to the offending line.

[fireflyon]

i know what line the code fails at, i just dont know why it work sometimes and others it doesn't

Sub Button4_Click() 
    inbounds_cmd.Show 
End Sub 

inbounds_cmd.show is where it fails. that code was located in a module. so i moved it to this workbook section, i changed the sub to this

Public Sub showuserform() 
    inbounds_cmd.Show 
End Sub 

i am using a shape and assigning the macro to it, so hopefully it works better. my question does it matter if the sub is declared as public or not? and does it maker where the code is located?

[norie]

Believe me that isn't the line of code causing the problem.

It might be the one highlighted when you select Debug, but it's the code that is triggered by that line that's the likely culprit.

And if you try my suggestion regarding Tools>Options... then you should find the real culprit.

[Dave Hawley]

what code is in the Intialize procedure? That will be the problem.