Status bar showing sum and count
 

I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya

Status bar showing sum and count
 

On Thu, 25 Sep 2008 21:11:26 -0700 (PDT), Madiya wrote:

I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya

Madiya,

You can try something like this (put the procedure in your worksheet's
code):
---
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.StatusBar = "Sum=" & _
Str(Application.WorksheetFunction.Sum(Target)) & _
"; Count=" & _
Str(Application.WorksheetFunction.Count(Target))
End Sub
---

HTH

B.

Status bar showing sum and count
 

In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel




"Madiya" wrote in message
...
I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya

Status bar showing sum and count
 

On Sep 26, 11:44*am, "Nigel" wrote:
In the customize status bar prior to xl2007 is limited unless you run some
of your own code. *Xl2007 offers a lot more options.

--

Regards,
Nigel


"Madiya" wrote in message

...



I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya

Status bar showing sum and count
 

what i do is copy a blank cell. then select the cells formatted as text, right
click, select pastespecial then add. it will change them to numbers.



--


Gary


"Madiya" wrote in message
...
On Sep 26, 11:44 am, "Nigel" wrote:
In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel


"Madiya" wrote in message

...



I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya

Status bar showing sum and count
 

"Madiya" wrote in message
...
On Sep 26, 11:44 am, "Nigel" wrote:
In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel


"Madiya" wrote in message

...



I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya


----------------------

Change Count to CountA

Regards,
Peter T

Status bar showing sum and count
 

On Sep 26, 7:33*pm, "Peter T" <peter_t@discussions wrote:
"Madiya" wrote in message

...
On Sep 26, 11:44 am, "Nigel" wrote:





In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel


"Madiya" wrote in message

....

I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya

----------------------

Change Count to CountA

Regards,
Peter T- Hide quoted text -

- Show quoted text -

Oh ..... so simple.
Thanks.
Madiya