Excel VBA Help

[mred2nice]

Good Morning

I have another question regarding VBA for Excel...

At the top of a button_click, I am trying to get this code to fire:
-OpenForm.lblHelp.Visible = True-

The label is not dsiplayed at the beginning of the click event. It is being dsiplayed at the end of the click event. Is there some kind
of DoEvent etc...type command I need to issue after settign the label to visible?

Thanks,
EJD

[RobDog888]

I think you want either ScreenUpdating or Refresh after you set
the label visible to true.

HTH

[Ecniv]

use doevents

lblName.visible=true
doevents:doevents

Its that the screen is not getting to be updated, so doevents hands processing back to windoze - useful if you don't want your app to appear non-responding.


Vince

[RobDog888]

I thought mred2nice tried doevents. It was in the first post.