PDA

View Full Version : progress bar for custom proceedure?



OTWarrior
10-18-2007, 09:16 AM
Is there a way of having a progress bar type messagebox, for when you start running code?

the main reason is my code can take up to 3 minutes, and to the user, it looks like it is doing nothing, and this would be a good visual indicator.

TonyJollans
10-18-2007, 09:25 AM
I suspect there's one in the Knowledgebase here.

TonyJollans
10-18-2007, 09:28 AM
Here's one: http://vbaexpress.com/kb/getarticle.php?kb_id=411

I just tried it and it flashes wildly so I'll see if I can look out another.

TonyJollans
10-18-2007, 09:31 AM
Here's another: http://vbaexpress.com/kb/getarticle.php?kb_id=169

OTWarrior
10-19-2007, 01:04 AM
sorry about that, I searched the forum, but I forgot about the knowledge base.

The last one is for excel, but it looks ideal (although I will have to figure out how to get it to work with my rather compicated macro),

Thank you :D