UserForm3.Show VBA Run-time error 424

[gheyman]

I am getting a Run-time error '424':
Object required

when I try to run this code
I have a UserForm3 not sure whats happening

Sub Execute()
'MsgBox "Please review the data on each of the ProPricer templates before exporting the data to ProPricer"

UserForm3.Show

            UserForm3.LabelProg.Width = 20
            UserForm3.LabelProg.Caption = "5%"
            DoEvents

EXMaterialsInput
Sheets("Step 6").Range("C12").Value = "Materials Input template updated: " & Now

            UserForm3.LabelProg.Width = 40
            UserForm3.LabelProg.Caption = "20%"
            DoEvents
            
EXMaterialDistribution
Sheets("Step 6").Range("C13").Value = "Material Distribution template updated: " & Now

            UserForm3.LabelProg.Width = 80
            UserForm3.LabelProg.Caption = "41%"
            DoEvents
            
EXAssemblies
Sheets("Step 6").Range("C14").Value = "Assemblies template updated: " & Now

            UserForm3.LabelProg.Width = 120
            UserForm3.LabelProg.Caption = "63%"
            DoEvents
            
EXAssemblyElements
Sheets("Step 6").Range("C15").Value = "Assembly Elements template updated: " & Now

            UserForm3.LabelProg.Width = 160
            UserForm3.LabelProg.Caption = "82%"
            DoEvents
            
EXProducts
Sheets("Step 6").Range("C16").Value = "Products template updated: " & Now

            UserForm3.LabelProg.Width = 195
            UserForm3.LabelProg.Caption = "98%"
            DoEvents
            
            
UserForm3.Hide

End Sub

the debug highlights
UserForm3.Show

 

[Anthony47]

There is something conceptually wrong with your code: when you execute UserForm3.Show the control pass to the userform and the rest of the macro will not execute until you close the form.
You could open the form using vbModeless, but this changes the way the form and the rest of your work area interact.

UserForm1.Show vbModeless

Using vbModeless the macro will continue after the userform opens, but I ignore what the commands EXMaterialsInput, EXMaterialDistribution and similar do, so I cannot foresee the overall result.

Bye

 

[RoryA]

Most likely the error is in the Userform_Initialize or Userform_Activate events in the form. In the VB Editor, change your error handling options (Tools - Options - General tab) to 'Break in class module' then try the code again and it should highlight the actual offending line of code.