Multi Line Tips (97)

[fburg]

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

[Klaus Linke]

Hi Fred,

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

[fburg]

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

[Klaus Linke]

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

[fburg]

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

[charlotte]

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