The 'other' status bar - that displays the sum of the selection
 

Hi
When you select cells in excel, the sum (or average or count etc.) is
displayed near the bottom right of the screen. I want to perform my own
calculation on the selected cells, and have the result displayed in the same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

You cane select from a variety of standard functions, but AFAIK cannot use
your own.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.) is
displayed near the bottom right of the screen. I want to perform my own
calculation on the selected cells, and have the result displayed in the
same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

There are a couple of different ideas. Here is just one option. This
displays the Count and Sum of your selection in the Lower Left corner (The
"Status Bar") and resets it after 5 Seconds. Maybe this will give you some
ideas to work with. HTH

Sub Demo()
Const z1 = "Count: # Sum: ##"
Dim s

With WorksheetFunction
s = Replace(z1, "##", .Sum(Selection))
s = Replace(s, "#", .Count(Selection))
End With

Application.StatusBar = s
Application.OnTime Now + TimeSerial(0, 0, 5), "ResetStatusBar"
End Sub

Sub ResetStatusBar()
Application.StatusBar = False
End Sub


--
Dana DeLouis
Win XP & Office 2003


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.) is
displayed near the bottom right of the screen. I want to perform my own
calculation on the selected cells, and have the result displayed in the
same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

You can select from a variety of standard functions, but AFAIK cannot use
your own.

Bob:

Piggybacking with a related question: Is it possible to programatically
change the "standard function" selected?

--
George Nicholson

Remove 'Junk' from return address.


"Bob Phillips" wrote in message
...
You cane select from a variety of standard functions, but AFAIK cannot use
your own.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.) is
displayed near the bottom right of the screen. I want to perform my own
calculation on the selected cells, and have the result displayed in the
same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

George,

Take a look he

http://www.dicks-blog.com/archives/2...lection-stats/

hth,

Doug

"George Nicholson" wrote in message
...
You can select from a variety of standard functions, but AFAIK cannot
use
your own.

Bob:

Piggybacking with a related question: Is it possible to programatically
change the "standard function" selected?

--
George Nicholson

Remove 'Junk' from return address.


"Bob Phillips" wrote in message
...
You cane select from a variety of standard functions, but AFAIK cannot
use
your own.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.) is
displayed near the bottom right of the screen. I want to perform my
own
calculation on the selected cells, and have the result displayed in the
same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

Doug:

Thanks, but my statusbar is otherwise occupied...

I was looking for a way to manipulate (or sometimes just turn off) this
"built-in" feature, not duplicate it, while leaving the rest of the Status
bar alone.

Thanks anyways.
--
George Nicholson

Remove 'Junk' from return address.


"Doug Glancy" wrote in message
...
George,

Take a look he

http://www.dicks-blog.com/archives/2...lection-stats/

hth,

Doug

"George Nicholson" wrote in message
...
You can select from a variety of standard functions, but AFAIK cannot
use
your own.

Bob:

Piggybacking with a related question: Is it possible to programatically
change the "standard function" selected?

--
George Nicholson

Remove 'Junk' from return address.


"Bob Phillips" wrote in message
...
You cane select from a variety of standard functions, but AFAIK cannot
use
your own.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.) is
displayed near the bottom right of the screen. I want to perform my
own
calculation on the selected cells, and have the result displayed in
the
same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

George,

I Googled and found a 1998 post from Tom Ogilvy. Here's the nut of it:

CommandBars("AutoCalculate").Controls("&None").Exe cute ' or &Sum or whatever

hth,

Doug

"George Nicholson" wrote in message
...
Doug:

Thanks, but my statusbar is otherwise occupied...

I was looking for a way to manipulate (or sometimes just turn off) this
"built-in" feature, not duplicate it, while leaving the rest of the Status
bar alone.

Thanks anyways.
--
George Nicholson

Remove 'Junk' from return address.


"Doug Glancy" wrote in message
...
George,

Take a look he

http://www.dicks-blog.com/archives/2...lection-stats/

hth,

Doug

"George Nicholson" wrote in message
...
You can select from a variety of standard functions, but AFAIK cannot
use
your own.

Bob:

Piggybacking with a related question: Is it possible to programatically
change the "standard function" selected?

--
George Nicholson

Remove 'Junk' from return address.


"Bob Phillips" wrote in message
...
You cane select from a variety of standard functions, but AFAIK
cannot
use
your own.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.)
is
displayed near the bottom right of the screen. I want to perform my
own
calculation on the selected cells, and have the result displayed in
the
same
way. Does anyone know how to set this value?
Thanks
Rob

The 'other' status bar - that displays the sum of the selection
 

LOL, Of course, its sooooo obvious! :-)

Seriously, thanks a lot (and to Tom too, of course!). Works like a charm.

--
George Nicholson

Remove 'Junk' from return address.


"Doug Glancy" wrote in message
...
George,

I Googled and found a 1998 post from Tom Ogilvy. Here's the nut of it:

CommandBars("AutoCalculate").Controls("&None").Exe cute ' or &Sum or
whatever

hth,

Doug

"George Nicholson" wrote in message
...
Doug:

Thanks, but my statusbar is otherwise occupied...

I was looking for a way to manipulate (or sometimes just turn off) this
"built-in" feature, not duplicate it, while leaving the rest of the
Status
bar alone.

Thanks anyways.
--
George Nicholson

Remove 'Junk' from return address.


"Doug Glancy" wrote in message
...
George,

Take a look he

http://www.dicks-blog.com/archives/2...lection-stats/

hth,

Doug

"George Nicholson" wrote in message
...
You can select from a variety of standard functions, but AFAIK
cannot
use
your own.

Bob:

Piggybacking with a related question: Is it possible to
programatically
change the "standard function" selected?

--
George Nicholson

Remove 'Junk' from return address.


"Bob Phillips" wrote in message
...
You cane select from a variety of standard functions, but AFAIK
cannot
use
your own.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
Hi
When you select cells in excel, the sum (or average or count etc.)
is
displayed near the bottom right of the screen. I want to perform
my
own
calculation on the selected cells, and have the result displayed in
the
same
way. Does anyone know how to set this value?
Thanks
Rob