Mouseover in Excel

[ef61778]

Can there be a mouse over caption for a command button on a woksheet?

 

[VBAjedi]

Not strictly speaking. But you can pop a small message box describing the button by using the MouseMove event:

Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
MsgBox ("This button does blah blah blah.")
End Sub

If you decide to go that route you will have to figure out a way to supress it after the first popup so it doesn't become an annoyance. Perhaps a global variable that you put the timestamp into so it cant display more than once every 5 seconds. . .

VBAjedi