VBA while calculating

[MarkCBB]

HI there VBA pros,

I am not too sure this is possible.

I have a very simple code that updates some databases with formulas. I turn the calculation type onto manual in the beginning of the code and then run the actual code, and then turn the calculation back to automatic and the end of the code.

Due the the amount of formulas that are being updated, this takes a very long time to complete. Is there a way I can have the statusbar show the progress of the calculations in percentage to completion?

 

[bensonsearch]

Hi,
you could use the progressbar to monitor how its going. I have read somewhere a way to use the status bar but can not find it again (sorry).

does the code use a loop do process the functions?

 

[Fazza]

What about addressing the slow formulas instead? Maybe they can be replaced?

 

[MarkCBB]

Hi there,

@bensonsearch, nope no loops in the code.

@Fassa, yup, all formulas are now working faster, the challenge is that the database is very big and is still growing. The only way I an think of adding a more visual display of the time that is needed for the calculations to complete is have a progress bar run at the same time as the calculation of the formulas but on a timer and I will just have to guess the time. but I am not sure how to approach or implement this. any tips?

 

[Fazza]

No, I don't know, Mark.

With a database type set up, perhaps though the formulas can be replaced - for example with UPDATE queries. Removing the formulas (totally) would really help, if possible.