Would there be an easy way to get linebreaks in ControlTipTexts?
I have seen a VB project from Brad Marinez that does this with subclassing
and the API:
http://btmtz.mvps.org/vbbubble/
and it might be possible to transfer this to VBA, but it won't be that
simple and I wonder
if there is a simpler way to this or if anybody has done this already in VBA
as in the above
VB project.

RBS

Saved from a previous post.

How about just putting a label 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

RB Smissaert wrote:

Would there be an easy way to get linebreaks in ControlTipTexts?
I have seen a VB project from Brad Marinez that does this with subclassing
and the API:
http://btmtz.mvps.org/vbbubble/
and it might be possible to transfer this to VBA, but it won't be that
simple and I wonder
if there is a simpler way to this or if anybody has done this already in VBA
as in the above
VB project.

RBS

--

Dave Peterson

Good idea, will give that a try.

RBS

"Dave Peterson" wrote in message
...
Saved from a previous post.

How about just putting a label 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

RB Smissaert wrote:

Would there be an easy way to get linebreaks in ControlTipTexts?
I have seen a VB project from Brad Marinez that does this with
subclassing
and the API:
http://btmtz.mvps.org/vbbubble/
and it might be possible to transfer this to VBA, but it won't be that
simple and I wonder
if there is a simpler way to this or if anybody has done this already in
VBA
as in the above
VB project.

RBS

--

Dave Peterson