Do userforms need initialization? - < Object variable or With block variable not set>

[yky]

Do userforms need special initialization?

I have two userforms, userform1 and userform2. Excel crashes when it comes to the line "userform2.show".

I checked both forms' properties in the debug window. Userform1.name was userform1. That is fine. However, when it comes to userform2.name, the debug window showed "< Object variable or With block variable not set>" and its type was integer, not string.

I have codes in userform1's initialization routine but not userform2's. That makes me wonder whether I need to initialize userform2.

 

[Norie]

How and when are you showing the forms?

Did you actually debug past the Show part?

Generally when you get en error there is something to do with the initialization.

It's usually the initialization code but not always, there could be something else happening.

 

[Ruddles]

ISTM that your second form's name may not be exactly what you think it is. When you try to access it, VBA assumes it's a new variable of type integer, then gets confused when you try to access its .Name property as if it were an object.

When you right-click on the form and go View Code, what's in the title bar of the code window?

Place this in the form's click event handler:-

MsgBox """" & Me.Name & """ (" & Len(Me.Name) & " chars)"

then run the form and click it. Any surprises in the message box?

 

[Norie]

Or you might have declared a variable somewhere with the name UserForm2.

If you want to check the name of a userform look at it's Name property while in design mode.

 

[yky]

How and when are you showing the forms?

Did you actually debug past the Show part?

Generally when you get en error there is something to do with the initialization.

It's usually the initialization code but not always, there could be something else happening.

Thank you for your reply.

Here is the entire code in UserForm2. I can't image what would go wrong.

When I ran only the form, it worked fine.

======================================
Option Explicit

Private Sub NoButton_Click()
Application.DisplayAlerts = False
Application.Quit
End Sub

Private Sub YesButton_Click()
Unload Me
End Sub

 

[RoryA]

Then I'd agree that either the form name is not what you think, or you have a variable by the same name, or perhaps the form is in a different workbook.

 

[yky]

ISTM that your second form's name may not be exactly what you think it is. When you try to access it, VBA assumes it's a new variable of type integer, then gets confused when you try to access its .Name property as if it were an object.

When you right-click on the form and go View Code, what's in the title bar of the code window?

Place this in the form's click event handler:-

MsgBox """" & Me.Name & """ (" & Len(Me.Name) & " chars)"

then run the form and click it. Any surprises in the message box?

Thanks for the reply.

I tried the message box. There is no surprise. The name of the form is UserForm2, length 9 characters.

 

[Ruddles]

Are you prepared to make the workbook available for inspection, either via a file-sharing site or via email?

The data can be removed.

 

[Norie]

What about the code for the other form?

 

[yky]

OK. I'm beginning to see the problem, maybe.

I have UserForm1.Show in sheet1's BeforeDoubleClick event and UserForm2.Show in module "main". Excel always crashes when it executes UserForm2.Show.

If I put UserForm2.Show in sheet1's BeforeDoubleClick event, right after UserForm1.Show (so, that event contains only two lines, UserForm1.Show and UserForm2.Show), there is no problem.

Anyone knows why?