Excel VBA - triggering a macro when mouse is hovered off a label

[BBxcl]

Hi,
I’m creating a dashboard in excel with a number of different charts. I wanted to add some text boxes at the bottom of each chart to explain what the chart is about but don’t want the text boxes to be visible all the time since it would clutter the dashboard.

I created a label and assigned it a MouseMove event that makes the text box visible when the mouse is moved over it. See code below:

Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
   Sheet2.Shapes(“TextBox 1”).Visible = True
End Sub

The problem is that when the mouse is hovered/moved off the label, the textbox stays visible. I would want to hide the textbox if the mouse is not on top of the label. I’m new to events so I’m not sure if such an event exists. Could anyone please help with this?

Many thanks in advance!

 

[GWteB]

The event you are referring to does not exist. You will have to solve this with another (transparent) label which is placed in Z-order directly under the first label, but which is considerably larger in size. In its mouse move event handler you include code that makes the text box invisible again.
Of course you increase the dimensions of the underlying label with code within the mouse move event handler of the top label which displays the text box.
This approach requires some trial and error, but it's not impossible.