Multiple entries put into string

G

gims289

I have a userform textbox that accepts multiple entries (Multiline = True).
The values of that textbox are then saved into a single cell to be called
later.

When calling that info and incorporating it into a string, how do I put a
comma between the entries that were originally entered?
 
S

smartin

gims289 said:
I have a userform textbox that accepts multiple entries (Multiline = True).
The values of that textbox are then saved into a single cell to be called
later.

When calling that info and incorporating it into a string, how do I put a
comma between the entries that were originally entered?
Click to expand...

Try something like

MyModifiedString = Replace(Me.TextBox1.Text, vbCrLf, ",")
 
R

Ron Rosenfeld

I have a userform textbox that accepts multiple entries (Multiline = True).
The values of that textbox are then saved into a single cell to be called
later.

When calling that info and incorporating it into a string, how do I put a
comma between the entries that were originally entered?
Click to expand...

Perhaps, in your code, REPLACE vbLF with ", "

--ron
 
Top