Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.

Macro working bar
 

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.