Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Range("A11:D11") values = one two three four
Option Explicit Sub TheT_Box() Dim MyStringVariable As String MyStringVariable = Range("A11").Value & ", " & Range("B11").Value _ & vbCr & Range("C11").Value & ", " & Range("D11").Value TextBox1.Text = MyStringVariable End Sub In the text box it displays this on a single line: one, two(Para Symbol)four, five Where (Para Symbol) is the two-staff backward P Copy that text string here it displays as: one, two three, four I want the later IN the text box. Is that in keeping with proper use of a Active X Text Box? Regards, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save As csv Carraige Return issue | Excel Worksheet Functions | |||
if AddIn_1 isRunning vbcr application.enableEvents=False vbcr end if: how to do this?? | Excel Programming | |||
carraige return within a cell & capitalization | Excel Programming | |||
Action A Carraige Return To A Text File | Excel Programming | |||
Action A Carraige Return To A Text File | Excel Programming |