MsgBox code countdown

[vio.coman]

Hi guys,

I have the following code that will be used by other users.
I need to add a 'statement' to my code that enables those users to visualize the time remaining till the completion of the code in the form of a MsgBox.

Is this technically possible!?

Any suggestions are much appreciated.

Thanks!

Please Login or Register  to view this content.

[HaHoBe]

Hi, vio.coman,

if you understand the same as I do when you wrote MessageBox my answer should be no as any MsgBox will halt the execution of the code until clicked (modal). One way around is to use the StatusBar and display the number of the actual record as well as the total number of records or the percentage reached or to try to make use of an UserForm for this.

Ciao,
Holger

[vio.coman]

Holger,

thank you! The option with the percentage reached is good enough.
How would I do that!?

Cheers

[HaHoBe]

Hi, vio.coman,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[vio.coman]

Holger,

thank you! It works perfectly.

regards