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: 66
Default Form won't update!

I have an form that works fine, after I click the OK button, it saves the
file. However this takes a while so I wanted to display a message 'Saving
File' I started by adding a lable, with the text, and setting it's visible
property yo false, and then when the buttonis clicked set it to true. I have
tried various ideas on this theme and to no avail. the only way I can get
such updates to work is by adding a call to display a msgbox, in the next
line of code.

How do I get around this?
Displaying the msgbox, requires user intervention, although I am sure I
could use a timer to get rid of it. But either way it seems wrong!

Graham
 
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
record update VBA form Roy Gudgeon[_2_] Excel Discussion (Misc queries) 0 March 15th 10 04:27 PM
update form RobcPettit[_2_] Excel Programming 1 October 4th 07 10:50 PM
Data Update Form Profairy Excel Programming 1 June 2nd 04 04:13 PM
Form Update before ProcRuns Nigel[_4_] Excel Programming 2 October 8th 03 04:15 PM
using vba to update vba form jrh Excel Programming 3 September 23rd 03 11:11 PM


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

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

About Us

"It's about Microsoft Excel"