Runtime error 424 Object Required

[GJennin7]

Hi Guy's, I am getting a run time error on the below two highlighted code lines. I do not have enough experience to understand what the problem is so would be extremely grateful for some assistance.

Sub UpdateProgress(pct)
    With ProgressIndicator
        .FrameProgress.Caption = Format(pct, "0%")
        .LabelProgress.Width = pct * (.FrameProgress.Width - 10)
    End With
'   The DoEvents statement is responsible for the form updating
    DoEvents
End Sub

 

[smozgur]

It looks like the ProgressIndicator is a user form that you are using to display the progress.

The error says that it cannot find an object called as "ProgressIndicator". So, you need to check this user form's name and make sure it is ProgressIndicator.

Unlikely, but possible, if it is not a user form but a custom control on the user form, then it is still the same problem but this time you need to click on that control on the user form, and verify its name in the object properties window.

Once you fix the name of the object, or change the code to use the actual object name, then it should work without problems.

 

[GJennin7]

Thanks for the advice. Much appreciated.

 

[smozgur]

Thanks for the advice. Much appreciated.

You're welcome.

May I ask what the exact problem was in your code, and how you solved it if it is solved?

 

[GJennin7]

You're welcome.

May I ask what the exact problem was in your code, and how you solved it if it is solved?

Sorry I did not respond to you on this. Not been back to the VBA for a while so not sure. But again thanks for your response.