Prev: Cosmetics
Next: Fix Broken Cell Formula with VBA
From: Subodh on 26 May 2010 18:40
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.
From: Dave Peterson on 26 May 2010 19:23
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
 | 
Pages: 1
Prev: Cosmetics
Next: Fix Broken Cell Formula with VBA