I have this snippet of code that worked yesterday and doesn't work today. I
didn't write it, so I'm still trying to figure it all out.

lblProgressText = ProgressLabel
'Get and error on the following line
'Either object required error and sometimes variable not defined e
ProgBar.Min = 0
ProgBar.Max = 60
ProgForm.Show

DoEvents

i've looked at the form and don't see anything titled "ProgBar". Where
should I look next? I saw this error yesterday and it went away. A user
has then tested the workbook where this code would have been used with no
errors.

Thanks,
Barb Reinhardt

Anyway, I'm getting an error as shown above.

I've found the problem. Some of the form was somehow deleted.

"Barb Reinhardt" wrote:

I have this snippet of code that worked yesterday and doesn't work today. I
didn't write it, so I'm still trying to figure it all out.

lblProgressText = ProgressLabel
'Get and error on the following line
'Either object required error and sometimes variable not defined e
ProgBar.Min = 0
ProgBar.Max = 60
ProgForm.Show

DoEvents

i've looked at the form and don't see anything titled "ProgBar". Where
should I look next? I saw this error yesterday and it went away. A user
has then tested the workbook where this code would have been used with no
errors.

Thanks,
Barb Reinhardt

Anyway, I'm getting an error as shown above.