Multiple entries put into string

[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?

 

[smartin]

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?

Try something like

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

 

[gims289]

That's what I was looking for. Thanks.

Try something like

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

 

[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?

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

--ron