sollijones
08-05-2013, 01:06 PM
Good Afternoon Forum Members! :hi:
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
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