View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
gims289 gims289 is offline
external usenet poster
 
Posts: 7
Default Multiple entries put into string

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, ",")