LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 157
Default Form label not updating immediately

I have a simple form with 2 command buttons and several labels.

CommandButton2 simply closes the file (Cancel).
This works OK.

CommandButton1 calls some code in a worksheet within the same workbook. This
code is intended to work in the background with the form still visible in
front. This part works.
This works OK.

Label7 is not visible initially and I want it to become visible as soon as
CommandButton1 is clicked. The label does not appear for several seconds
after clicking the button. I added the timer to try to give the label time
to be displayed before moving on, but much of the called code has processed
before the label appears.

As the label simply asks the user to wait while the code runs, this isn't a
lot of use.

Any ideas?

--
Ian
--


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Concatenate to form a label gwendalee Excel Discussion (Misc queries) 3 October 16th 07 12:59 AM
Hyperlink on a label in a VB Form Gaetan Excel Discussion (Misc queries) 4 May 28th 07 12:35 PM
Form label not showing Les Stout[_2_] Excel Programming 0 October 17th 06 11:00 AM
COPY LABEL FORM FROM EXCEL TO A LABEL xrayAndi New Users to Excel 1 March 5th 06 02:21 PM
Disable Label in a Form Stuart[_21_] Excel Programming 4 March 13th 05 11:04 PM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"