Possible form error.

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Not Defined 3
Error handling best practices 4
DIR not working after first workbook opened. 2
Excel 2003 Runtime error 40036 6
Working with PPT files through Excel VBA 2
Copying Worksheet from one workbook to another 1
Object Library feature not supported 8
GetFolder error 6

Back
Top