This code crashes excel (unless the VBA editor is open)

[RawlinsCross]

Good day,

I have the following code that was crashing my excel when it executed. Oddly enough (and by accident), I discovered that when the VBA editor is open, the code runs fine. So I know how it's happening but not why it's happening.
Any thoughts to why this is happening and perhaps suggestions to replace the code with something more robust?

Dim UForm As Object

For Each UForm In VBA.UserForms
    If UForm.Name = "UserGUI" Then
        Exit Sub
    End If
Next UForm

 

[ajetrumpet]

Oddly enough (and by accident), I discovered that when the VBA editor is open, the code runs fine.

unfortunately that makes no sense. doesn't look like there's anything wrong with the code, to me. the only thing that might make a difference, which if it did, would make even less sense than this whole situation of your yours, would be changing:

Dim UForm As Object

to this:

Dim UForm As userform

you know, I've been scolded on other forums for bashing microsoft products, but unfortunately they are well known for crashing without reason. This could just be a case where you're working with a terrible application. just one man's opinion....

 

[RoryA]

Anyone who thinks Excel is a terrible application, clearly doesn't know how to use it.

 

[ajetrumpet]

Anyone who thinks Excel is a terrible application, clearly doesn't know how to use it.

it was just an opinion, Rory! somehow I knew one of you guys would throw fire at me for that one!

 

[RoryA]

As was mine, hence the wink. (Although if you actually do think that Excel is just terrible, you're clearly delusional...)

 

[ajetrumpet]

As was mine, hence the wink. (Although if you actually do think that Excel is just terrible, you're clearly delusional...)

let's not hijack this thread...i'll send you a PM.

 

[RawlinsCross]

Take it outside!!! hahaha.

Anyhow, if you change as suggested (i.e. Dim UForm as Userform), apparently you cannot use UForm.Name as the that property does not exist?

 

[RoryA]

You'd have to use Typename(UForm) instead of UForm.Name

 

[RawlinsCross]

Hmmmm… still crashing if VBA Editor is not open.

 

[ajetrumpet]

I'm not sure what to tell you, Rawlins. But to quote those most famous words spoken by so many MS Access "professionals":

try reinstalling office