Button suddenly failing to load userform

[RockandGrohl]

Hi all,

Since last week, this was working and absolutely nothing has changed. We have three buttons to load userforms. One of them is a control panel to load various buttons that execute macros and this works totally fine.

The other two are done when there is an active cell selected. It takes the information on that row and loads data, last week these were working as they have been for the last several years, but today it seems like they are broken inexplicably. No changes to the core working structure of this sheet have been made, or really any changes at all, since last week.

When I press either button, I get "Run Time Error 440, Automation Error" displayed.

Here is the code:

Sub cpopen()

Load ControlPanel
ControlPanel.Show

End Sub

Sub pupopen()

Load PUpCheckBox
PUpCheckBox.Show

End Sub

Sub pcopen()

Load PCodeCheck
PCodeCheck.Show

End Sub

It's the PUpCheckBox and PCodeCheck that aren't working. When I mouse-over the name, it says "Object Variable or With Block variable not set"

The userforms are there and 100% correctly named in the object information window.


I loaded the 2019 version of this same sheet and confirmed the macros and userforms are set up 100% identically, yet this sheet has no problem loading the forms.

 

[Fluff]

In the VB Editor goto Tools > options > General & check the box marked "Break in Class Module" and then try to run the code.

 

[RockandGrohl]

In the VB Editor goto Tools > options > General & check the box marked "Break in Class Module" and then try to run the code.

Hi Fluff, good to see you.

Tried this and it shows the exact same behaviour - I click the button and it says Automation Error, with "PUpCheckBox" highlighted in yellow, and mousing over Load PUpCheckBox gives me the "Object Variable or With Block Variable not set" message.

 

[Fluff]

If you comment out the Load line, do you get the same error when you try to show it?

 

[RockandGrohl]

If you comment out the Load line, do you get the same error when you try to show it?

Yep, still 440 Automation Error

 

[Fluff]

Are the userforms in the same workbook as the buttons?

 

[RockandGrohl]

Are the userforms in the same workbook as the buttons?

Yep, there is one module which I pasted above, the rest of the code is contained within the buttons in the control panel, or the two checking userforms which I am having problems with.

 

[Fluff]

In that case I don't know. I cannot recreate that error.

 

[RockandGrohl]

In that case I don't know. I cannot recreate that error.

Hi Fluff,

I've just created a new module, copied the content over and then the code. Deleted the old "PCodeCheck" and tried to rename the new "UserForm1" to "PCodeCheck"

It says "Path/file access error"

Another clue?

 

[Fluff]

If you check the references are any listed as Missing?