Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    UserForm | Control Tip Text (XL 2002)

    While in the VisualBasic Editor, I have applied a ControlTipText to a label using the properties form. The Tip contains the notation P&L. When actually using the UserForm, the tip displays as PL. How can I force it to display it as I have intended?
    - Ricky

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm | Control Tip Text (XL 2002)

    Use P&&L
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Multi Line ControlTip

    Yep, that did it! - Thanks Legare

    Another thing... Is it possible to force a controltip to use two lines (or more) by entering a return symbol?
    - Ricky

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multi Line ControlTip

    No I do NOT think so (at least in XL97)
    You can add the carriage return and line feed, put the control tip doesn't seem to allow wrapping and it "displays" these "symbols" as vertical lines

    You can add them in the activate event with a line like:
    <pre>Label1.ControlTipText = "Line 1" & vbCrLf & "Line 2"</pre>


    but it shows like attached.

    Steve

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi Line ControlTip

    In Excel 2002, vbCrLf doesn't have the desired effect either. The question has come up several times in the MS Newsgroups, and the answer is that is simply isn't possible.

    (Note: multi-line control tip texts are possible in Access; it has its own rather different version of forms)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •