Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Multiple line controltiptext

Hello.

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

Thanks..
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multi-line controltiptext SteveDB1 Excel Programming 0 September 18th 08 11:28 PM
ControlTipText SteveDB1 Excel Programming 1 September 18th 08 10:47 PM
ControlTipText Nigel Excel Programming 1 May 2nd 07 06:19 PM
ControlTipText davidm Excel Programming 1 February 21st 06 04:36 AM
ControlTipText style phreud[_4_] Excel Programming 0 June 9th 04 09:09 PM


All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"