Format userform Text field values

Hi,
I am working with Excel 2003 UserForm. I want to paste Sheet1.range"A2:A600" values in my userform.txtVal field which is a text box... and the values needs to be pasted in the Sheet1.range B2 in below format
A2.Text, A3.Text..A600.Text ..likeways

Please help.
LVL 9
suvmitraAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
suvmitraConnect With a Mentor Author Commented:
The below code is working
 ActiveCell.Offset(0, 14) = Replace(txtInv, Chr(13), ",")
0
 
hitsdoshi1Commented:
Will something like this work ?

Sub cpyrange()
ctr = 2
Do While ctr < 601
    Range("B" & ctr) = Range("A" & ctr)
    ctr = ctr + 1
Loop
End Sub

Otherwise attach a sample file to get better idea what exactly you asking for...

Thanks
0
 
suvmitraAuthor Commented:
I want to copy a range say..A1:A25 (any length) --then want to paste in a TextBox field of a Userform (Multy Line is true).
Now when I return to my worksheet I find the cell is looks like as attached.
 
I want these values in one single cell .. delimitted in comma ... 1,2,3,4 ...

1.JPG
0
All Courses

From novice to tech pro — start learning today.