Having trouble with "vbcr"

  • Thread starter Thread starter terrysoper1973
  • Start date Start date
T

terrysoper1973

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 retur
symbol is printed and I have only one continous line. Here is sampl
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
line under that says "balance sheet"

Please help

Thanks
Terr
 
Previous post was solved with vblf instead of vbcr, but won't work with
textboxes

'works with cells but not with text boxes
msg = worksheets("sheet1").range("a3")
worksheets("sheet2").range("c7") = msg + vblf + "Balance sheet"

If I want to do the same thing, but using a textbox for the
destination, how is it done.

'displays vbcr or vblf code
Private Sub cb1_Click()
msg = Range("b2") + vbLf + "balance sheet"
'works with range
'Worksheets("sheet2").Range("a1") = msg
'doesn't work with textbox
Worksheets("sheet2").TextBox1.Text = msg
End Sub

One more try please, just using a textbox, and I'll get out of your
hair.
Terry


Please help

Thanks
Terry


terrysoper1973
View Public Profile
Send a private message to terrysoper1973
Find all posts by terrysoper1973
Add terrysoper1973 to Your Buddy List
 
Back
Top