Having trouble with "vbcr"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


When I use "vbcr" in trying to display text in text boxes and cells,
Instead of my text being moved to the next line, the carriage return
symbol is printed and I have only one continous line. Here is sample
code of what I tried:

msg = worksheets("sheet1").range("a3")
worksheets("sheet2").range("c7") = msg + vbcr + "Balance sheet"

I'm attempting to move whats in "a3 sheet1" to "c7 sheet2" and add a
line under that says "balance sheet"

Please help

Thanks
Terry


--
terrysoper1973
------------------------------------------------------------------------
terrysoper1973's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30161
View this thread: http://www.excelforum.com/showthread.php?threadid=498434

.

Relevant Pages

  • Is it possible to put a JPanel within a JTable cell?
    ... cells such as Combo boxes, check boxes, etc.. ... Is it possible to add a JPanel to a JTable ... would like to display items of type JPanel.class, ...
    (comp.lang.java.programmer)
  • Is it possible to put a JPanel within a JTable cell?
    ... cells such as Combo boxes, check boxes, etc.. ... Is it possible to add a JPanel to a JTable ... would like to display items of type JPanel.class, ...
    (comp.lang.java.programmer)
  • Userform Defaults Text Box with Time
    ... values currently in the cells to display in the text boxes. ... Private Sub UserForm_Activate ...
    (microsoft.public.excel.programming)
  • Text boxes in forms
    ... I have a set of forms that capture user-inputed data. ... boxes to record the input and copy it to specific cells on a spreadsheet. ... the carriage return forces the cursor to move to the ... What I want is the text from each box on the form copied to specific cells ...
    (microsoft.public.excel.programming)
  • Multiple combo boxes
    ... selected from 2 combo boxes to produce a given output. ... second combo box to display only the data from cells B1 to ... and again from the first combo box selecting 'A2' to ... display only the data from cells C1 to C10. ...
    (microsoft.public.excel.worksheet.functions)