Control Tip Text from Cell

[Jornyboy]

Good Afternoon,

Is there any way to make the control tip text in a VBA user form return the value of a cell?

Thanks in advance!

Jorn

 

[p45cal]

the likes of:

CommandButton1.ControlTipText = Sheets("Sheet10").Range("C1").Value

?

 

[Jornyboy]

Yes! But what type of sub command should that exist with?

 

[p45cal]

Yes! But what type of sub command should that exist with?

With an event related to the user from such as the
Private Sub UserForm_Initialize()
event, but any other userform event you choose, depending on when the value in the cell is likely to change while the userform is showing.