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: 18
Default Screen Updating

Is there a way I can show the progress of a long piece of code by
showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being written to the form
isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes longer to run
and it makes the screen flicker (in a really annoying fashion!)

I hope there is a way where I can have UserForms updating with the rest
of the application not updating?


I hope someone out there can help me, as I am really stumped on this one.


TIA

 
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
SCREEN NOT UPDATING ub Excel Worksheet Functions 2 March 18th 09 11:52 AM
Screen Updating Michael Excel Worksheet Functions 3 March 14th 05 09:53 PM
Screen updating Mark Stephens Charts and Charting in Excel 0 February 18th 05 03:55 PM
Screen Updating Chilidog1000[_2_] Excel Programming 1 January 6th 04 08:18 PM
Screen Updating Jase Excel Programming 1 October 23rd 03 05:05 PM


All times are GMT +1. The time now is 04:53 AM.

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"