I
Interactive worksheet
Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?
over that particular cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary Brown
Only by using VBA (Visual Basic for applications)
HTH,
HTH,
I
Interactive worksheet
Gary,
How long and difficult is the code? Can you give me a vb code that will do
what i want for just one cell?
How long and difficult is the code? Can you give me a vb code that will do
what i want for just one cell?
D
Dave Peterson
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
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
I
Interactive worksheet
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?
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?
D
Dave Peterson
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)
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)