Having trouble with "vbcr"
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 -- terrysoper197 ----------------------------------------------------------------------- terrysoper1973's Profile: http://www.excelforum.com/member.php...fo&userid=3016 View this thread: http://www.excelforum.com/showthread.php?threadid=49843 |
Having trouble with "vbcr"
Use vbLf instead of vbCr.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "terrysoper1973" <terrysoper1973.216h2s_1136491811.8662@excelforu m-nospam.com wrote in message news:terrysoper1973.216h2s_1136491811.8662@excelfo rum-nospam.com... 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...o&userid=30161 View this thread: http://www.excelforum.com/showthread...hreadid=498434 |
Having trouble with "vbcr"
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 -- terrysoper1973 ------------------------------------------------------------------------ terrysoper1973's Profile: http://www.excelforum.com/member.php...o&userid=30161 View this thread: http://www.excelforum.com/showthread...hreadid=498434 |
Having trouble with "vbcr"
terrysoper1973 wrote:
Previous post was solved with vblf instead of vbcr, but won't work with textboxes vbcrlf :) |
All times are GMT +1. The time now is 10:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com