VBA - MouseMove Event Code to Display Text after Hovering

[sollijones]

Good Afternoon Forum Members!

I am new to VBA Express and am looking forward to learning a lot.

Here is my issue. I've added MouseMove code to CommandButtons in order to display text when a user hovers over the command button. However, I realized that now the user cannot actually click the button to perform the respective function. Please help! I've taken a VBA course many years ago, so basically I'm a complete novice. I am using Excel/VBA 2010.


This is a modification request to provide users the ability to mouse over a command button to view a description and also select/click the same command button to perform the related function.

Here is an example of the current code:

Private Sub CommandButton13_MouseMove(ByVal Button As Integer, ByVal Shift As Integer,


ByVal X As Single, ByVal Y As Single)
MsgBox "Validate Amounts "
End Sub

Many thanks in advance for your assistance, knowledge and expertise.

Simone