multi-line controltiptext

[taupirho]

Using VBA on XL97 and would like to create a multi-line controltiptext. I have tried following code but no luck.

userform1.label1.controltiptext = "Line 1" & vbcrlf & "Line2"

Also tried ctrl-Enter at design time and no luck.

Anyone cracked this?

 

[PaulTEG]

try

controltiptext="firstbit"+chr(10)+"secondbit"

I seem to remember that working - chr(10) is just the linefeed character not "carriage return/line feed"

HTH
;P

 

[taupirho]

PaulTEG,

Unfortunatley your answer does not appear to work. On my machine the CHR(10) character appears as small
black square between Line1 and Line2.

 

[PaulTEG]

What OS are you running, and more particularly what character set?

The character set could be the problem

Are you getting the same small black square with vbCrLf

P

 

[RobBroekhuis]

Same on my XL2000 machine "A" & vbLf & "B" gives just a vertical bar between the A and the B. I don't think control tips are meant to go more than 1 line. I couldn't find an example of one in any application that does. Rob

 

[TonyJollans]

Me too! With the following code:

For i = 0 to 255
St = St & Chr(i)
Next i
.ControlTipText = St

I got as much of a long single line of tip as would fit on the screen but no second line. So I can't find any character to do the trick although there might be some combination that works.

Enjoy,
Tony