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: 2
Default How to speed up VBA program in Excel?

Hi Everyone,

I wrote a Macro in VBA that calculate something, and there are three
loops in it. In short, it runs terribly slow... which is obvious...
because the program displays all the change of certain values on screen
during the processing...

My question is how to speed up it? How to put the computing behind
screen just like C programm... such as 'compile first then run' style?

I really need some help because I was a C/C++/VC programmer other than
VBA programmer... any idea would be welcomed.

Thank you in advance!



Leon

 
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
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene LunaMoon Excel Discussion (Misc queries) 0 July 28th 08 11:03 PM
Q re program speed, with 15k lines of data asyado Excel Programming 5 April 27th 06 09:02 PM
Speed up Program Process maperalia Excel Programming 3 January 26th 06 07:54 PM
merging excel program with tdc finance program judy Excel Programming 0 November 5th 03 08:01 PM
program speed problem chris[_3_] Excel Programming 1 September 11th 03 02:05 AM


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