Posted to microsoft.public.excel.programming

Sliman

external usenet poster

Posts: 13

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
label caption	gramps	Excel Discussion (Misc queries)	0	November 1st 07 03:56 PM
Changing label caption in a Userform to an opterator value	jumpjump	Excel Programming	2	August 25th 05 01:50 AM
Userform - Label Caption - How to update from a variable	Alan	Excel Programming	3	August 2nd 04 04:39 AM
Label Caption Just Wont Work on UserForm	K[_3_]	Excel Programming	2	September 15th 03 03:29 PM
label caption	Rod Taylor	Excel Programming	2	July 31st 03 03:25 AM

All times are GMT +1. The time now is 03:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us