Excel: Can I display a chart when the mouse is over a cell?

[F Schmitt]

I have a worksheet and i need to be able to have a range of cells from
another worksheet display when the mouse pointer is over a certain cell on
the first worksheet. Is there a way to do this?

 

[Tushar Mehta]

If the range of cells is static and the contents of those cells don't
change, you could create a comment for the cells in the first worksheet
and put the values of other other worksheet in the comment.

Other than that I cannot think of any other way, not even with VBA
since XL doesn't raise any event when the cursor is over a particular
cell.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions