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-


.

Relevant Pages

  • Re: Will this SQL work to find records with hard returns in one of the text fields?
    ... >>There's a VBA constant, vbCrLf, that you can use for this, and use ... as it doesn't walk through the string character ...
    (comp.databases.ms-access)
  • Re: Linefeed to CrLf
    ... onlu puts a Lf character at the end of each row. ... Dim s As String ... vbcrlf replace and doing something like: ...
    (comp.databases.ms-access)
  • Re: Making .res with RC.exe discards carriage returns
    ... vbCrLF & vbCrLF & _ ... However in the resource string table I only see a single unprintable ... Ctrl-Enter gives me the carriage return in the Textbox. ... RC will compile the .res with carriage returns. ...
    (microsoft.public.vb.general.discussion)
  • Re: Linefeed to CrLf
    ... onlu puts a Lf character at the end of each row. ... Function ReadAll(path As String) As String ... Dim s As String ... vbcrlf replace and doing something like: ...
    (comp.databases.ms-access)
  • Re: Making .res with RC.exe discards carriage returns
    ... vbCrLF & vbCrLF & _ ... I can successfully make a *.res file using RC.exe from the command line. ... However in the resource string table I only see a single unprintable ... Ctrl-Enter gives me the carriage return in the Textbox. ...
    (microsoft.public.vb.general.discussion)
Quantcast