View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_1031_] Simon Lloyd[_1031_] is offline
external usenet poster
 
Posts: 1
Default Assigning control tip text


Don't use the string $, you can use a number of ways
Code:
--------------------
MsgBox "This is a" & vbLf & "test for" & Chr(10) & "adding new" & vbNewLine & "Lines!"

--------------------
each of the new line commands can be used on thier own or mixed as
seen, but best practice would dictate that you stick with one!

kirkm;231004 Wrote:
Can you add a linefeed programicably?

I'm finding chr$(13) and vblf etc. just print a square in the text.

Thanks - Kirk



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64545