Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Interactive Worksheet
Is there a way for cells to change format or font when the mouse pointer is
over that particular cell? |
#2
|
|||
|
|||
Only by using VBA (Visual Basic for applications)
HTH, -- Gary Brown "Interactive worksheet" wrote: Is there a way for cells to change format or font when the mouse pointer is over that particular cell? |
#3
|
|||
|
|||
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? "Gary Brown" wrote: Only by using VBA (Visual Basic for applications) HTH, -- Gary Brown "Interactive worksheet" wrote: Is there a way for cells to change format or font when the mouse pointer is over that particular cell? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Office 2003 will not view interactive Worksheet saved as a web pa. | Excel Worksheet Functions |