Run Time Error 424 - Object Not Found

[Denny57]

Suddenly my Command Buttons to open User Forms are not working in one file each time I try to open a User Form and I receive the Run Time Error 424.

When I run the debugger, I am taken to the Module which opens the form and the form name is highlighted.

Macros are enabled and forms in other files open.

Sample

Sub CallUserForm()

    frmPreservedSteamLocomotives.Show

End Sub

There are 4 Command Buttons in 4 different worksheets in the same workbook, none of which now work.

Any suggestions?

 

[Micron]

check that the name is correct, including capitalization and that you didn't remove any form controls that are referred to in the initialize event, assuming you have one.

 

[Anthony47]

In addition to what suggested by Micron, above:
Try excecuting Sub CallUserForm step-by-step using (from the vba editor) F8

Probably, after frmPreservedSteamLocomotives.Show, excecution will continue with some initialization macro; any error in that phase would abort the form opening, try to catch wich is the aborting instruction and probably that will suggest also the reason

 

[Denny57]

Micron

Thank you for your response. It would appear that MS Windows Common Controls was no longer present in the Tools - References and so had removed the DTPicker control from the forms. I can only assume that this must have happened during a MS365 upgrade.

I have now been able to reload these controls and put the DTPicker back into the forms

 

[Micron]

Glad to see you got it solved!