View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
42N83W 42N83W is offline
external usenet poster
 
Posts: 19
Default How to do a line feed in a Text Box

Excel 2002
Windows XP Pro SP2

I've tried vbcrlf but that just places the "p" looking carriage return
character in my string. Here is the gist of what I want:


OUTPUT = "The Input value is " & VAL & vbCrlf & _
"The Input units are " & INP & vbCrlf & vbCrlf

txtbx2.Value = OUTPUT

Any ideas?


-gk-



=================================================
The creative act is not the province of remote oracles or rarefied geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-