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
Bookmarks