Want to show Sum and Count of selection range in Lable

[HaroonSid]

hi everyone

i want to the sum and count of selection in lable2 or textbox

thanx

[Keebellah]

What label? Can you be more explicit?
What version of Excel?

[HaroonSid]

thanx for the reply

excel 2013

i want to show the sum of selected range and count them and result show to a textbox, or cell (like a1) or lable

i was trying to do like below

Please Login or Register  to view this content.

but its not working properly

[HaroonSid]

Like excel's status bar does

[Keebellah]

It's not a Workbook action but a Worksheet action:

Please Login or Register  to view this content.

You will need to add some suf like checking if a range has been selected and more things like that.

[Keebellah]

Something more like this:

Please Login or Register  to view this content.

[HaroonSid]

Oh!

yes its working perfectly

thanx Keebellah

[HaroonSid]

i have one more question

i want to show that sum of selection in textbox1
is it possible dear?

[Keebellah]

Then you have to send it too the textbox.

It's generally something like

Please Login or Register  to view this content.

This depends on the type of textbox you insert.

[HaroonSid]

Keebellah

i want to result in textbox as i select range,
i don't want beforerightclick or moveup or movedown event

thanx for the reply

[Keebellah]

There needs to be a trigger to update a textbox

[HaroonSid]

Got the solution

thanx dear

Please Login or Register  to view this content.

[HaroonSid]

i used lable instead of a textbox