I have a spreadsheet with quite a few worksheets in it, and a macro that
allows users to search through all the worksheets for certain information.
Sometimes it takes a couple of seconds; sometimes it may take 10-12-15.
While it searches, it displays a form to indicate it is searching.

Is there any code out there that would allow the form to have some kind
(anykind) of 'search' indicator - the moving circle of dots, or bars, or
whatever - like you see on web sites (such as travel sites while they are
searching for fares). Or is there some other way to put something
semi-active on the form so it isn't just sitting there?

Thanks

--
Bill @ UAMS

Andy Pope has a variety of progress bars available on his site:

http://andypope.info/vba/pmeter.htm

There is a free download and notes on how to incorporate them into your own
code.

Hope this helps.

Pete


"BillCPA" <Bill @ UAMS wrote in message
...
I have a spreadsheet with quite a few worksheets in it, and a macro that
allows users to search through all the worksheets for certain information.
Sometimes it takes a couple of seconds; sometimes it may take 10-12-15.
While it searches, it displays a form to indicate it is searching.

Is there any code out there that would allow the form to have some kind
(anykind) of 'search' indicator - the moving circle of dots, or bars, or
whatever - like you see on web sites (such as travel sites while they are
searching for fares). Or is there some other way to put something
semi-active on the form so it isn't just sitting there?

Thanks

--
Bill @ UAMS

Looks great - thanks!

--
Bill @ UAMS


"Pete_UK" wrote:

Andy Pope has a variety of progress bars available on his site:

http://andypope.info/vba/pmeter.htm

There is a free download and notes on how to incorporate them into your own
code.

Hope this helps.

Pete


"BillCPA" <Bill @ UAMS wrote in message
...
I have a spreadsheet with quite a few worksheets in it, and a macro that
allows users to search through all the worksheets for certain information.
Sometimes it takes a couple of seconds; sometimes it may take 10-12-15.
While it searches, it displays a form to indicate it is searching.

Is there any code out there that would allow the form to have some kind
(anykind) of 'search' indicator - the moving circle of dots, or bars, or
whatever - like you see on web sites (such as travel sites while they are
searching for fares). Or is there some other way to put something
semi-active on the form so it isn't just sitting there?

Thanks

--
Bill @ UAMS