Split a long text in a userform textbox to multiple rows on a worksheet

**newbi004** · 08-31-2012, 08:05 AM

Hi

I have a textbox in a userform where the user can input information. This text could be quite long and when it is printed on a worksheet cell, will overlap that cell.

How can I create a vb code that will print only, say max 30 characters per row?

Any advice will be much appreciated.

Thanks

**tom1977** · 08-31-2012, 08:12 AM

Hi something like:

Please Login or Register  to view this content.

**newbi004** · 08-31-2012, 08:24 AM

Thanks Tom, but wouldn't this only print the first 30 characters? How can I adapt your code to print the remaining characters in multiple rows?

**tom1977** · 08-31-2012, 08:44 AM

maybe

Please Login or Register  to view this content.

??

**newbi004** · 08-31-2012, 09:03 AM

Not sure if that would help because I wouldn't know how much text the user will input. If I keep using discrete cell code, I could be over or under the total length. Also, I would not want words to be split when the max length of 30 characters is reached. Maybe Len, Mid and Left is not the way here.

Thanks anyway.