ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple line controltiptext (https://www.excelbanter.com/excel-programming/431323-multiple-line-controltiptext.html)

Murat[_3_]

Multiple line controltiptext
 
Hello.

Is it possible to show multiple line controltiptext in an userform easily?

Thanks..

Dave Peterson

Multiple line controltiptext
 
Saved from a previous post.

How about just putting a label (with as many lines as you want) over the control
and that control in a frame.

Then when you mouse over the frame, it'll hide the label. But when you mouse
over the control, you'll show the label.

Option Explicit
Private Sub CommandButton1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Me.Label1.Visible = True
End Sub
Private Sub Frame1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Me.Label1.Visible = False
End Sub

Murat wrote:

Hello.

Is it possible to show multiple line controltiptext in an userform easily?

Thanks..


--

Dave Peterson

Murat[_3_]

Multiple line controltiptext
 
Thanks David.

I found a code which I implemented to mine, works good:

http://www.andypope.info/vba/whatsthishelp.htm

That is better for me.




"Dave Peterson" wrote:

Saved from a previous post.

How about just putting a label (with as many lines as you want) over the control
and that control in a frame.

Then when you mouse over the frame, it'll hide the label. But when you mouse
over the control, you'll show the label.

Option Explicit
Private Sub CommandButton1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Me.Label1.Visible = True
End Sub
Private Sub Frame1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Me.Label1.Visible = False
End Sub

Murat wrote:

Hello.

Is it possible to show multiple line controltiptext in an userform easily?

Thanks..


--

Dave Peterson



All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com