How do I make custom hover labels? Excel

excel vba hover label mousehover
Jax-El picture Jax-El · Dec 5, 2013 · Viewed 8.8k times · Source

Is there a way to have a hover box display something other than "Series "POSITION" Point "2/24/2012" Data Label"? I would like to make a custom hover label. I know there are similar posts, but I am looking for a simpler solution. The related posts I felt were trying to do something much more difficult than mine. I simply want data on a chart from columns A and B, but want to display information from column C when hovered over a data label.

I have tried:

Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    If X > 10 And X < Label1.Width - 10 And Y > 10 And Y < Label1.Height - 10 Then
        ActiveSheet.Range("C21").Visible = True
    Else
        ActiveSheet.Range("C21").Visible = False
End If
End Sub

But this hasn't worked yet. The original poster said to mess with the 10 value, but I haven't seen any improvement. Also, how do I know which label is "Label1."?

Thanks! Jaxon

Answer

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops

How can I use regular expressions in Excel and take advantage of Excel's powerful grid-like setup for data manipulation? In-cell function to return a matched pattern or replaced value in a string. Sub to loop through a column of data …

Read More