.textbox update in a sheet takes more time than acceptabel

F

frank112

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
 
P

Patrick Molloy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populate and update textbox 1
Macro: Save and update/replace comments in a list - tricky task 0
Class module and a lot of records 1
Expression Builder basic question on syntax / Or / how to incorporatea SQL query into a textbox cont 16
How do you undock or move a property sheet in Acccess 2007? 2
Update record with save button after populating a textbox from combobox? 4
Change textbox/combobox colors with a procedure 9
Slowness but more subtle in PPT 2007 and 2010 Beta! 2

Top