Thread: Change label caption on userForm while code runs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sliman Sliman is offline
external usenet poster
  
Posts: 13
Default Change label caption on userForm while code runs
I am wanting to change label caption on userform while code runs.
Have got it working as follows inserted in break in VB but is there a
better way?

UserForm1.Hide
UserForm1.Show vbModeless
UserForm1.Label1.Caption = "Step 2 in progress"
Application.Wait Now + TimeValue("0:0:01")

Thanks
Simon

Reply With QuoteReply With Quote