Progress Indicator?

[Anthony Slater]

Hi

I have a fairly large work book with a 'front end screen'
that acts as an input area. Only One cell in this first
sheet is available for the user.

Upon entering a value in the available cell, various
information is 'pulled' from the workbook using lookups
etc...

To gather all the rested information it can take roughly
10-15 seconds.

How can I add some sort of progress indicator to the front
screen after the value has been entered in the available
cell?

Thanks in advance

 

[Jason Morin]

MVP Andy Pope has several unique ones:

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

HTH
Jason
Atlanta, GA

 

[Anthony Slater]

I went to that site but as I'm very new to VB I found it
quite confusing.

Basically, if someone enters a value in cell A1 and
presses enter, a progress indicator would pop up.

I just don't know how to go about it.

Stumped....

 

[Jason Morin]

Why would you want to run a progress indicator if someone
is just going to enter a value in cell A1? Now if doing
so triggers some macro to run, then you can incorporate
the progress indicator. Andy's workbook provides all the
code (you can see it by pressing ALT+F11, right-click on
UserForm, View Code) as well as the userform. If you are
new to VB, then trying to build this same type tool into
your workbook is going to be challenging.

Jason