Excel VBA - Wordwrap conundrum

  • Thread starter Thread starter Simon Caddy
  • Start date Start date
S

Simon Caddy

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

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

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

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

Thank you.


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
Back
Top