Help please Challenging - VBA needed to create a highlighted row

[Eric Cotton]

Hi there.

I would like to have a macro, that I can use.
When I hover my mouse over any row, in the background eg. my mouse is over cell d4 , I want the whole row d4 to be highlighted.

But note that it would be better to have eg a shape highlight the row and not a colour highlight such as yellow. Because what I find is that If eg I have tables already highlighted, or I would like to highlight some cells, it will interfere. Any ideas.

 

[revcanon]

You might try some of the techniques found here:

http://www.mrexcel.com/forum/excel-questions/194053-changing-shape-fill-color-mouseover.html

or

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell | OPTION EXPLICIT VBA

 

[Eric Cotton]

Hi there. Thanks for trying. I can't get these to work. Can someone else please assist ?

You might try some of the techniques found here:

http://www.mrexcel.com/forum/excel-questions/194053-changing-shape-fill-color-mouseover.html

or

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell | OPTION EXPLICIT VBA