Display Command Button Caption in VBA

[SOLLIJONES]

Hello Forum Members,

Can you please advise me how to modify the below code in order to briefly display the button caption when hovering over it with the mouse cursor.

Thanks in advance for your assistance.


Private Sub CommandButton5_Click()
Header_Insert
End Sub


Best Regards,
Simone

 

[Worf]

Hello Simone and welcome to the Board

I'm assuming the button is inside an user form:

' this goes at the userform module


Private Sub UserForm_Initialize()
        
    With Me.CommandButton1
        .ControlTipText = .Caption
    End With
    
End Sub