I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

thanks but I got the little circle going around but I can not make it to
stop...

"Jacob Skaria" wrote:

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Do you mean; to revert back

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"
Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True
Application.Cursor = xldefault
Application.StatusBar = False

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

thanks but I got the little circle going around but I can not make it to
stop...

"Jacob Skaria" wrote:

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Have not been able to see the a´plication status bar message.... I even put
the macro on break mode to see if it was going too fast bt never showed up

"Jacob Skaria" wrote:

Do you mean; to revert back

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"
Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True
Application.Cursor = xldefault
Application.StatusBar = False

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

thanks but I got the little circle going around but I can not make it to
stop...

"Jacob Skaria" wrote:

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Try the below on top...
Application.DisplayStatusBar =true

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

Have not been able to see the a´plication status bar message.... I even put
the macro on break mode to see if it was going too fast bt never showed up

"Jacob Skaria" wrote:

Do you mean; to revert back

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"
Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True
Application.Cursor = xldefault
Application.StatusBar = False

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

thanks but I got the little circle going around but I can not make it to
stop...

"Jacob Skaria" wrote:

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Thanks... it is already over midnight so I will try it tomorrow.

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Thanks I´ll try it tomorrow... too late already... past midnight

"Jacob Skaria" wrote:

Try the below on top...
Application.DisplayStatusBar =true

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

Have not been able to see the a´plication status bar message.... I even put
the macro on break mode to see if it was going too fast bt never showed up

"Jacob Skaria" wrote:

Do you mean; to revert back

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"
Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True
Application.Cursor = xldefault
Application.StatusBar = False

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

thanks but I got the little circle going around but I can not make it to
stop...

"Jacob Skaria" wrote:

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

I finaly saw the status bar but it is at the bottom of the screen... is there
any way to put it in the midle of the screen...?
Thanks

"Jacob Skaria" wrote:

Try the below on top...
Application.DisplayStatusBar =true

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

Have not been able to see the a´plication status bar message.... I even put
the macro on break mode to see if it was going too fast bt never showed up

"Jacob Skaria" wrote:

Do you mean; to revert back

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"
Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True
Application.Cursor = xldefault
Application.StatusBar = False

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

thanks but I got the little circle going around but I can not make it to
stop...

"Jacob Skaria" wrote:

Application.Cursor = xlWait
Application.StatusBar = "Please wait...<some activity in Progress"


If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

I acess the below www and get to see some nice samples but in all the status
bar is at the very bottom of the screen hard to see... can I move it to
midle of the screen...

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

No, you can't move the status bar.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I acess the below www and get to see some nice samples but in all the
status
bar is at the very bottom of the screen hard to see... can I move it to
midle of the screen...

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with
info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so
user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Any other way to do so....?

"T. Valko" wrote:

No, you can't move the status bar.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I acess the below www and get to see some nice samples but in all the
status
bar is at the very bottom of the screen hard to see... can I move it to
midle of the screen...

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with
info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so
user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

Not that I know of.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
Any other way to do so....?

"T. Valko" wrote:

No, you can't move the status bar.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I acess the below www and get to see some nice samples but in all the
status
bar is at the very bottom of the screen hard to see... can I move it
to
midle of the screen...

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with
info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so
user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.

See Andy Pope's site for a workbook with various progess bars.

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


Gord Dibben MS Excel MVP

On Thu, 10 Sep 2009 21:15:01 -0700, Alberto Ast
wrote:

Any other way to do so....?

"T. Valko" wrote:

No, you can't move the status bar.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I acess the below www and get to see some nice samples but in all the
status
bar is at the very bottom of the screen hard to see... can I move it to
midle of the screen...

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/Progress.htm

Also note at the bottom of the page the reference to other sites with
info
on this.

--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
I have a long macro runing under
Application.ScreenUpdating = False
but I would like to have a bar showing in prograss or some action so
user
will know system is working and not freeze up.
Something similar as windows does to show something is happening.

Thanks.