Tooltip on Labels

[magelan]

I have an ActiveX Label that is an extremely long file name and is being shortened. Is there any way to slap a tooltip onto a Label object so they can hover over it and see the full filename if they need to?

[Rob342]

Try this

Application.ShowToolTips = True
With Me.label1 'The name of your label
.ControlTipText = "Click In The Box & Enter Your Password " ' Change to suit
End With

[magelan]

Try this

Application.ShowToolTips = True
With Me.label1 'The name of your label
.ControlTipText = "Click In The Box & Enter Your Password " ' Change to suit
End With


That doesnt seem to be a valid property on a label [atleast my activex label]

[Rob342]

I thought you were using a label on a form
refer to this post, this could answer your question
http://www.vbaexpress.com/forum/showthread.php?t=15084

Rob