View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KD[_3_] KD[_3_] is offline
external usenet poster
 
Posts: 15
Default Excel VBA - carriage returns

Hi,

I am writing some vba code to split up some text that has
been entered in textboxes, and in every case there appears
to be carriage returns at the end of each line. Is there
a way I can strip out each line and store it in to a
seperate variable (eg line1,line2,line3 and line4 - there
are a maximum of 4 lines per textbox)?

Many thanks
KD