How about just having the thing that disables the control also change the
tooltip.
Option Explicit
Private Sub CommandButton2_Click()
With Me.CommandButton1
.ControlTipText = ""
.Enabled = False
End With
End Sub
Private Sub UserForm_Initialize()
With Me.CommandButton1
.ControlTipText = "hi there"
.Enabled = True
End With
End Sub
And the thing that enables the control would set the tooltip back.
Dave, I was thinking more in terms of the following: When I open Excel,
The icons for the UNDO, PASTE... , I assume are disabled (maybe that's a bad
assumption) and yet when you bring the cursor over them it still displays
the toolTip. I want to do that on a userform.
Thanks