DASHBOARDS THAT INTERACT ON MOUSE MOVE

In my earlier post, I showed you how to create Excel Dashboards that interact when a cell is CLICKED or SELECTED. The link to that post is given below.

Dashboards that Interact on Cell Clicks

Now lets get a bit lazier 🙂 . Why do we have to click. Can’t we just get the Dashboards to interact on moving the Mouse’s cursor to desired item.

If you remember we used the Worksheet_SelectionChange event to create DASHBOARDS that interact on cell Clicks. When a Cell inside a predefined Named Range was clicked, Application.Intersect method gave us the Value of the Cell which became the basis of Dashboard’s Interaction

Unfortunately there is no such available event as Worksheet_MouseMove although we have Mousebased events like Worksheet_BeforeDoubleClick and Worksheet_BeforeRightClick

The trick here is to use the HYPERLINK function in Excel along with a User Defined Function (UDF) but DOESN’T OUTPUT anything in itself.

What HYPERLINK does is that it forces the code inside UDF to run even if the Code is unrelated to the function.

 

Click here to Download this file    and play with code. I am sure you will find more creative uses for this trick