displaying a message with the hourglass

[t16turbo]

my macro takes a while to run, so I was hoping to be able to display a pop up box to the user, so they know it's doing something (and not crashed)

is this possible?

 

[rmikesmith]

There are multiple ways to give feedback to the user. I suggest searching this forum using the words 'progress bar' as a start. Rob VanGelder has an interesting progress bar that runs in the Statusbar. His website is

http://homepages.paradise.net.nz/~robree/excel/

Regards,
Mike

 

[t16turbo]

thanks Mike,

i looked at that link, but I cant see how I can use that code in conjunction with my Modules run by calling the first one:

Call openfobs

not sure where the call statement needs to go..

 

[rmikesmith]

As you could probably tell from VanGelder's example, the progress bar type indicator is best suited to code that is executing in a loop with a fixed number of iterations, since the progress bar typically expands to its max value (100%) coinciding with the end of the loop operation. I assumed that was your case. If, instead you simply have a macro that takes an extended period of time to complete, without being easily quantifiable, then the simplest solution may be to display a custom message via a Userform at the start of the macro, then Unload it when the macro completes. The Userform will need to be displayed as a modeless form; e.g.,

Userform1.Show vbModeless

Regards,
Mike