VBA form not being recognised by the code

[Chris_Hed]

Hi All,

I've searched this forum and others without success solving this weird problem. It might be an Excel bug, but I'm hoping it's just something I'm doing wrong.

My fairly basic spreadsheet has two userforms. One works perfectly well but the other won't even load. It did when I first created it but now isn't recognised by the code.

Observed behaviour:

• The form appears to be correct in design and code windows (VBA editor)
• Form name appears to be recognised in the code because capitalisation "errors" are automatically corrected.
• Load(userform2) throws error 424 (object required). When hovering over the line in debug mode, it shows userform2 = <Object variable or With block variable not set>
• Set Frm = userform2 throws error 424 (object required). When hovering over the line in debug mode, it shows userform2 = <Object variable or With block variable not set>
• Dim Frm as New userform2 throws error 424 as well.

Things I've tried:

• exporting then importing the userform
• saving the excel sheet as a new file
• disabling then re-enabling the macros
• removing and reauthorising trusted locations and documents.
• repairing Office 365 (short and long versions)

I'm really running out of ideas on this one so all suggestions welcome

 

[Jaafar Tribak]

Sounds like you have a variable named userform2 within your project. Find that variable and change its name.

Also, if the following works, it means it is probably the above variable naming issue :

VBA.UserForms.Add("UserForm2").Show

 

[Chris_Hed]

Sounds like you have a variable named userform2 within your project. Find that variable and change its name.

Also, if the following works, it means it is probably the above variable naming issue :

VBA.UserForms.Add("UserForm2").Show

Thanks for taking the time to reply.

I should have also listed that I tried renaming the userform as well without success. I'm certain that there is no variable by any of those names in the project (the form name is actually frm_NewIncident, so pretty hard to use without noticing).

I tried the code you suggested and got the same error 424 (object required) highlighting that line of code. In debu mode there was no mouseover text.

 

[Chris_Hed]

OK, more troubleshooting and a little more info.

When importing the exported file into a brand new workbook, the behaviour followed it. The other (working) form imported and worked just fine.

It seems to be something specific to the form and I might just need to accept remaking it from scratch