i was wondering if it were possible to roll over a cell with your cursor like in column B2 and have a little box pop up with the sum value in that cell?

Jham wrote:

i was wondering if it were possible to roll over a cell with your cursor
like in column B2 and have a little box pop up with the sum value in
that cell?

Can you clarify what it is that you want? The value of the cell is what's
displayed by default, unless you have Excel set to display formulae instead.

--
I think we better rethink this thing!

There is no rollover event in Excel.

I suspect this statement is not true since this is how cell comments
are displayed. Too bad, though, that it's not exposed...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

put your numbers in column A (starting cell A1), then put this formula =HYPERLINK(SUM($A$1:A1);A1),
in column B and pull down.
Colum B will show the same numbers as in column A, but when you roll over a cell it will show the sum of all the cells above.
Hope this is what you mean.