ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   To show a message box if the mouse is over a particular cell?? (https://www.excelbanter.com/excel-programming/442833-show-message-box-if-mouse-over-particular-cell.html)

Subodh

To show a message box if the mouse is over a particular cell??
 
Is there a particular way to display a message box,(or run any other
sub) if the user puts the mouse over it lets say for cell A1. Like it
display comments for cells that have comments in them. Since, there is
a property of in excel to response to mousehover, I expect that this
can be done.

Dave Peterson

To show a message box if the mouse is over a particular cell??
 
I don't think you'll find a solution in excel for that mouse over a cell
problem.

But if you could rely on change of selection, you could tap into the
worksheet_selectionchange event.

That'll fire if you use the mouse, arrow keys, page up/down, ...

Subodh wrote:

Is there a particular way to display a message box,(or run any other
sub) if the user puts the mouse over it lets say for cell A1. Like it
display comments for cells that have comments in them. Since, there is
a property of in excel to response to mousehover, I expect that this
can be done.


--

Dave Peterson


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com