Hi Everyone.
I have an excel file, there is a lable (lable1) cover the range that I want to highlight a cell within that range in red when a mouse is over that cell location. The event Label1_MouseMove in sheet1 suppose to determine location of the mouse on the range and do the highlight work. However, I found that when the range is larger than the screen, the mouse and the highlighted cell does not always be at the same spot.
I have upload the file to the below host. Please kindly let me know how to address the issue or if you have a better way to acheive what I am going after, please help share with me the code.
http://www.easy-share.com/1917924300/Lable_MouseMove.xlsm
Thank you very much.
CEO76
I have an excel file, there is a lable (lable1) cover the range that I want to highlight a cell within that range in red when a mouse is over that cell location. The event Label1_MouseMove in sheet1 suppose to determine location of the mouse on the range and do the highlight work. However, I found that when the range is larger than the screen, the mouse and the highlighted cell does not always be at the same spot.
I have upload the file to the below host. Please kindly let me know how to address the issue or if you have a better way to acheive what I am going after, please help share with me the code.
http://www.easy-share.com/1917924300/Lable_MouseMove.xlsm
Thank you very much.
CEO76
