Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Multi Line Tips (97)

    Hi All,

    Been a long time since I've been on this board. Maybe this has been answered so just point the way if so.

    I can use a VBA statement like
    CommandBars(cbrname).Controls(controlnum).TooltipT ext = ttext
    to set the tooltip text of a particular control on a particular commandbar.

    If ttext (a string) has a vbcrlf as part of it, the tooltip text comes out over multiple lines. Good.

    However, if I use an Inputbox to query a user as to what the tooltip text should be, how can I allow a line enter as part of the text? I tried lots of combinations of various SHIFT, CTRL, ALT keys plus Enter but none worked. Either they did nothing or they invoked whatever button had the focus (OK unless I had used tab to set the focus on Cancel). Is there some way to say neither button should have the focus? Would that allow me to have an enter as part of the text?

    Thanks for any help.

    Fred

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Line Tips (97)

    Hi Fred,

    If you want to keep it simple:
    Dim Text
    Text = InputBox("Enter string (

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Multi Line Tips (97)

    Hi again Klaus,

    Good idea - keep it simple. I like that. I like your suggestion for how to do this.

    As far as wanting to have line returns: why not? By using the VBA statement as I had it:
    ...controls(x).tooltiptext = ttext
    where ttext had been built up thru concatenation including a vbcrlf, I can do it (and I did do it with that "Insert Microsoft Excel Worksheet"). I know that none of the existing tooltip texts have line returns. What the heck - why conform?

    Thanks again.

    PS: did you edit your original message? What I got via email differed from the Web site thread in that the former talked about having a Close button and didn't have your last para.

    Fred

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Line Tips (97)

    Perhaps somebody else has an idea on how to get a ^13 into an InputBox string... I don't know for sure whether this is impossible.

    > PS: did you edit your original message?

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>Yes, I did...
    I often only see my mistakes when the message is posted; should use the preview window, shouldn't I?

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>Klaus

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Multi Line Tips (97)

    Klaus,

    >I often only see my mistakes when the message is posted; should use the preview window, shouldn't I?

    I didn't even know there was a Preview window until about a month or 2 ago. I ended up losing a long response that had some [pre] tags in it bcs I didn't realize that automatically threw you into the preview window when you posted. Maybe the answer is that the system doesn't send the email until some small delay after you post to give you a chance to edit or it sends you both copies. Personally, I think it would NOT be productive to have to use the preview window every time just to avoid this situation.

    Now what can I edit in the above after I've posted it... <img src=/S/devil.gif border=0 alt=devil width=15 height=15>

    Fred

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multi Line Tips (97)

    You can replace the <Cr> with a vbCrLf and it will work nicely too.
    Charlotte

Posting Permissions

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