Dowsey1977
10-28-2005, 05:51 AM
Hi,
I've currently got a macro that runs when an object is clicked. This opens up a custom made form, which then triggers a macro that opens the 'Open File' dialogue box and a sheet from a spreadsheet is copied over. After this another macro is called that moves information around on the sheets.
What I want is a progress bar to appear that runs whilst the macro is running so that the user knows that the programme isn't just hanging and doing nothing. The progress bar I found here seems ideal...
http://vbaexpress.com/kb/getarticle.php?kb_id=87#instr
However, I'm not sure where to put this in my existing code??
I would paste my code in but it is pretty long!
Any ideas?
:help :bug: :doh:
I've currently got a macro that runs when an object is clicked. This opens up a custom made form, which then triggers a macro that opens the 'Open File' dialogue box and a sheet from a spreadsheet is copied over. After this another macro is called that moves information around on the sheets.
What I want is a progress bar to appear that runs whilst the macro is running so that the user knows that the programme isn't just hanging and doing nothing. The progress bar I found here seems ideal...
http://vbaexpress.com/kb/getarticle.php?kb_id=87#instr
However, I'm not sure where to put this in my existing code??
I would paste my code in but it is pretty long!
Any ideas?
:help :bug: :doh: