On mouseover Excel 2007

[Excelnoub]

Good morning to all,

I was just wondering if this is even possible to do.


I am looking for a method to have a mouse over text box to view extra information.

I have an Excel Calendar (by year) with events. Same as the template that is offered by Microsoft.


I was wondering if it would be possible to have that same calendar to have a mouse over with extra information once the user selects a date that would be highlighted.

The dates has a conditional formula that if column L = the number then that number on the calendar will change color. Now beside column L you can write some events or comments.


I was just thinking if it would be possible to have this info to be somehow, if the user goes on that date in the calendar to have some kind of text box appears and the user would be able to view the text/description.


Kind of looking for a sort of java script or dynamic tool but in excel.


Just looking for an easier way.


I have this off the web:

[pre]

Private Sub TextBox1_MouseMove(ByVal intButton As Integer, ByVal intShift As Integer, ByVal sngWidth As Single, ByVal sngHeight As Single)

If (sngWidth < 5 Or sngWidth > TextBox1.Width - 5) Or (sngHeight < 5 Or sngHeight > TextBox1.Height - 5) Then
TextBox2.Visible = False
Else
TextBox2.Visible = True
End If

End Sub

[/pre]

 

[Excelnoub]

Also just wondering if I convert the file in html will it process the information or do I just try to do it in HTML (java). Just wondering if this is possible in excel as I will need to start from Scratch all of my 2012 and 2013 info within my excel calendar.