Not in regular VBA--maybe using some highfalutin' API calls (way beyond me!)
would work.

If it's only certain cells, you could add comments to those cells. When you
mouse over a cell with a comment, the comment pops up (tools|options|View
tab|comment indicator only checked)

Interactive worksheet wrote:

This RowLiner is a good idea but unfortunately, the excel file is going to be
used by other people and i am assuming that if they dont have rowliner
installed, it's not going to work on their work stations. There is no code
in vb that i can use to make a cell stick out when the mouse pointer scrolls
over the contents of a cell?

"Dave Peterson" wrote:

Not by just moving the mouse over the cell. You could do something that would
change the format when the cell is selected (either by mouse or by keyboard).

If you're looking for something that would make the selected cell stand out
better, you may want to try Chip Pearson's utility:

http://www.cpearson.com/excel/RowLiner.htm

Interactive worksheet wrote:

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?

--

Dave Peterson


--

Dave Peterson