Move into new cell instead of line break

[Soulfien]

I'm trying to add in a userform into a spreadsheet at the new company at which I work.
Unfortunately, I'm forced to use their existing sheet instead of starting from scratch... (I still may, however).
They use merged cells (gag) and as such, the listbox value won't grow the cell on wordwrap as it will if the cells aren't merged. Some of the values are a bit too long and they either bleed into the next column or they word wrap (causing the new line to not be visible).

The userform I'm using is a multi-select dual listbox userform with an Add, Remove, and Transfer Button
Here's the code for the userform's transfer button:

Please Login or Register  to view this content.

Is there a way to have it split into a new cell instead of word wrapping?

Please Login or Register  to view this content.

This may not be possible in which case I'll have to come up with something else. Thanks!

[ptmuldoon]

Can you post a working sample? Others are much better than me with working working and splitting strings. You can probably set a string length and anything greater than that length move to row beneath it. But you could likely also being splitting in the middle of word. And if possibly inserting a new row beneath it, that cell may follow the formatting of the cell above it and and also wrap.

What if you need to add 2 rows beneath it?

[jolivanes]

Have a look here
http://www.excelforum.com/excel-prog...uto-shape.html

[Soulfien]

What if you need to add 2 rows beneath it?

After the useform's transfer button has dumped its data to the active cell for as many rows as needed, the user can just type in values as normal to the rows still beneath the data. That's not an issue.

I could post the spreadsheet I suppose...

Here's the code I got from that link, provided:

Please Login or Register  to view this content.

Do you know how I could incorporate this into the userform's transfer button?

Thanks for the replies so far!


The userform's button is at the bottom of the page.