MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How activate a macro when either move the mouse over a cell or clicK

  Asked By: Bonni    Date: Nov 23    Category: MS Office    Views: 2121

If I have a macro XXXX already defined, how can I automatically
invoke it when the mouse is just move over the cell or when the cell
is clicked?



2 Answers Found

Answer #1    Answered By: Clarence Nichols     Answered On: Nov 23

Again, see the example file. You'd probably want the
Worksheet_SelectionChange event for this, but I don't think it's
possible to fire a macro  simply on mouseover in Excel.

Answer #2    Answered By: Geena Ma.     Answered On: Nov 23

I wanted to do it also, but my research found it is
not possible. The only option is one of the worksheet events.