LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,298
Default .textbox update in a sheet takes more time than acceptabel

you've upgraded -- hmm, thats a bit of an abiguous word in this context...so
you switched to Excel 2007? There's been many reports of performance
issues.Try adding a line:

Application.ScreenUpdating=False

"frank112" wrote:

Hi Guys,
I have a sheet with a lot of dynamical textboxes based on data and content
from another sheet. When a run a routine to update the text within the
textboxes it takes approx 0.5 sec pr update where it took next to nothing in
VBA\Word2003. Any idea what has changed and how I may ressolve this issue?

best regards
frank112

 
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
how to generate '*' in a textbox field that takes a password? NA_AB[_2_] Excel Programming 1 January 16th 09 01:22 PM
ODBC takes time to update kaiser Excel Programming 2 June 12th 07 01:34 PM
macro that takes data entered in a user form textbox to go to a ra BrianMo Excel Programming 5 September 22nd 06 03:52 PM
time sheet that takes out taxes Jake Excel Worksheet Functions 0 January 11th 06 03:32 AM
Textbox on excel sheet do not update with VBA Ben Joiner Excel Programming 4 November 6th 03 11:07 AM


All times are GMT +1. The time now is 12:31 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"