Is Excel ignoring my commands?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have put labels, text boxes and a command button on the front sheet of my
workbook instead of using a userform (Different issues there).

Label4 is supposed to update while the code is running to advise the user of
progress.

It will not update unless I step through using F8. When I step through it
works perfectly.

I know this works, because the last two updates are working using the same
code.

I have tried turning ScreenUpdating on just before or just after the update.
Nothing seems to work. I think Excel is just ignoring it the rest of the
time.

I am using:

Sheets("Instructions").Label4.Caption = "*"

Any suggesetions?
 

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

Error handling part way though code 1
User Defined Password 1
Routine too fast for Form to Update? 1
UserForm Label Caption from Cell contents 2
Compile directive for 2000 to ignore 2003 commands 1
Application.quit error 3
automation error 0
Adding hyperlink to access database from excel 1

Back
Top