My macro takes a long time to run - need to speed it up or add a progress bar

[songhaegyo]

Hi all,

First of all i want to thank the community here for helping me out. it has been a long and tedious process for me so far but i learnt a lot. I am stuck on this at the moment.


It takes very long to load when i adjust the "data" sheet, Cell B1 to 10 and run my macro.
Is there a way to optimize the code or to add a progress bar?

This is tough for me.

[Keebellah]

The progress bar, no problem but is that the macro named Test?

You should learn to cleanup you VBA project, Give the modules decriptive names and and use Option Explicit so that you are sure that all variables are formatted correctly.
If you create order in you chaos it will make it easier to maintain

[Keebellah]

There is a nice tutorial here
http://wellsr.com/vba/2017/excel/bea...-instructions/
I have my own code but you can start practicing with this one.

I'll put mine together for your macro and update when I am finished

[songhaegyo]

There is a nice tutorial here
http://wellsr.com/vba/2017/excel/bea...-instructions/
I have my own code but you can start practicing with this one.

I'll put mine together for your macro and update when I am finished

Many thanks!!

[Keebellah]

I do not know what you did but your macro stops here

Please Login or Register  to view this content.

Please correct and resend the file

[xladept]

You're macro ran in an instant

[songhaegyo]

Happy sunday guys.

I just tried it, the macro works fine for me.
This is the macro in module 1, first sheet under the "data" tab.
Button 1.

Reattached spreadsheet.

@XLADEPT - the macro starts to underperform when i increase the iterations in cell B1... It is meant to perform up to 10/11 nodes. But its horribly inefficient.

[Keebellah]

Well, then there is something wrong with the version you are attaching

[Keebellah]

I found the reason for the error. That is what happens when you do not take into account different country settings.
The value in strStart is the timestamp but since it is coded like this the value decimal value is incorrect.
I'll ignore it and work with it.

[Keebellah]

Having look at that I am returning the file where I placed the progress bar form in

[songhaegyo]

Hi Keebellah,

What do you mean by the value decimal value is wrong ? How do i account for different country settings?

[Keebellah]

The decimal symbol is not the same with every country setting.

In some it is a . in other like here it is a ,