B
BillCPA
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
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