Is it Possible?

[Jham]

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

 

[Auric__]

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.

 

[Tristan Goderis]

There is no rollover event in Excel. But a cool way to work around this is working with the hyperlink formula. It does require some VBA knowledge though.
check out this page : http://optionexplicitvba.blogspot.be/2011/04/rollover-b8-ov1.html

 

[GS]

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

 

[Tristan Goderis]

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.