Excel VBA - Wordwrap conundrum
 

I am designing a 'program' in excel to help capture information on form
that are received by my employer. the idea is that the user fills i
the blanks, and the pre-defined text is completed with the added dat
using the concatenate function. However, this information is then to b
copied from excel and pasted into a program that is specific to ou
job. This program only allows 72 characters per line of text, and DOE
NOT wrap text across lines.

So, if you are 5 spaces from the end of the line, and wish to typ
'sentence' you end up with 'sente' on the first line and 'nce' on th
second.

I am looking for a way for count back from the end of the line (if yo
are still typing at that point, i.e. last character of line is not
space) to the last 'space' that was entered, then force a carriag
return, and start the process again. This has to be able to handle u
to 1000 characters.

If you know of a way to do this, I would be ecstatic if you could tel
me how it is done. Oh yeah, the text is all kept in a certain cell (L
at the moment).

Thank you.

Shackdelta:confused

--
Message posted from http://www.ExcelForum.com