Insert Line Breaks in Textbox

Hi There,

I'm fairly new to VBA and was wondering if someone could help me with this. I've got a multiline textbox on a spread sheet being used to capture text which will then be pasted into my companies memo system. What I want to do is add a command button that when pressed inserts a line break every six lines of text.

i.e. the user would enter this:
text 1
text 2
text 3
text 4
text 5
text 6
text 7
text 8

then press the control button and get this:
text 1
text 2
text 3
text 4
text 5
text 6

text 7
text 8

with a line break between 6 and 7. I'd like to have this repeat every 6 lines.

Any help would be much appreciated

it's from the control toolbar

Hi

I am struck up in my code and getting error. It is pretty simple one.


I have to copy values from column 32 row 3 onwards i.e. cell (x,32) to
column C row 3 onwards i.e. cell(x, C).
Column C is column whose row 2 contain today's date.


I hope I am clear. To simplify this I am taking an example:-


If cell (2,45) contain todays date then copy all cells(3 onwards, 32)
to cells(3onwards,45).
If cell(2,50) contain todays date then copy all cells(3onwards,32) to
cells(3onwards,45).
If cell(2,100) contain todays date then copy all cells(3onwards,32) to
cells(3onwards,100)
If cell(2,200) contain todays date then copy all cells(3onwards,32) to
cells(3onwards,200)


If anything is unclear, please let me know so that I can send you the
file.


Regards
San

thanks! that works perfectly