Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 2nd 06, 04:19 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2005
Posts: 11
Default Multiline Tooltip

Is there a simple way to get the tooltip in an Excel form to be multiline
or wrap? In my search I have seen very complex VB examples to simple add a
Chr(13), add HTML <BR to add a "|"... of which none of those worked.
Appreciate any suggestions.

Thanks, Rob

  #2   Report Post  
Old May 2nd 06, 07:30 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Multiline Tooltip

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


RobC wrote:

Is there a simple way to get the tooltip in an Excel form to be multiline
or wrap? In my search I have seen very complex VB examples to simple add a
Chr(13), add HTML <BR to add a "|"... of which none of those worked.
Appreciate any suggestions.

Thanks, Rob


--

Dave Peterson
  #3   Report Post  
Old May 2nd 06, 09:34 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2005
Posts: 11
Default Multiline Tooltip

Dave,

Excellent idea...

Thanks,
Rob




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
How a Tooltip can be displayed? amateur New Users to Excel 2 October 22nd 09 09:24 AM
Tooltip for my CommandButton LQs Excel Discussion (Misc queries) 1 December 2nd 05 09:53 AM
tooltip text Duraiswamy Lingappan Links and Linking in Excel 1 April 7th 05 07:51 AM
UDF tooltip Dave Excel Programming 2 April 26th 04 03:17 PM
Tooltip on lineshape Wouter Excel Programming 0 November 25th 03 04:31 PM


All times are GMT +1. The time now is 07:17 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017