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

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.

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

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

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

"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

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