progress bar

[Stefan]

Hello,

Can anyone tell me how I can show a progress bar while a module is
converting data. I import large text files and this take up to 2 minutes. So
it seams that the computer crashes when importing.

I tried to give feedback to a form but the changes made to the form are not
visible until the procedure has ended.

 

[Ken Snell \(MVP\)]

You need to repaint the form after you "update" its visual contents. Then
you will see your progress.

 

[Stefan]

Thank you for the information

Now I can fill up the textbox with a log.

Best regards
Stefan Baens

 

[Sam D]

Stefan,

Search for SysCmd in VBA help. Tells you how to initialise, update and
remove a progress meter.

Sam