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

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