I have a number of Active X buttons in a sheet and I am using the
to show a shape holding a description of what the button will do once clicked.
As I will have multiple buttons for different functions, is it possible to create one set of code to work dynamically with the button index e.g. btn1, btn2, btn3, etc.
The code needs to de exactly the same for each button which is to make a shape visible, change it's caption and position above the button being hovered over.
Thanks
VBA Code:
Private Sub btn1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
As I will have multiple buttons for different functions, is it possible to create one set of code to work dynamically with the button index e.g. btn1, btn2, btn3, etc.
The code needs to de exactly the same for each button which is to make a shape visible, change it's caption and position above the button being hovered over.
Thanks