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?

gims289 wrote:
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, ",")

That's what I was looking for. Thanks.

"smartin" wrote:

gims289 wrote:
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, ",")

On Tue, 11 Aug 2009 15:36:01 -0700, gims289
wrote:

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