Help in auto fit text with multiline and next line in VBA in a auto merge cells

[excelvbanew]

Hi everyone,

I encountered some difficulty when i was doing a cell row value where if they contain too many words and new line then the row will hide the word
Currently i am using an user form for the user to fill in the text then it be put into my merge cell as what my requirement is enterkeybehaviour and multiline is set to true
as currently my cell is being merge together A4:C4

however i believe autofit dont work with merge cells is there a way no matter how much i type in my userform text when it paste into the Cell of A4:C4 all the words can see clearly ? i have discovered than an row limit height at 409.2 there which mean we will need to merge the next row to show the words fully if the word exceed the amount

I have attached the file as an example of what i am doing.

Please help!

[Sintek]

Rule No 1 in Excel Vba...Don't use merged cells...

[excelvbanew]

is it possible say i unmerge first then merge it back ?

[Sintek]

When in doubt see rule no 1

[excelvbanew]

even say is unmerge is there a way where i can autofit the 1000 word whether there is a space etc in the cell ??

[Sintek]

Just populate them below each other...What is it you are actually trying to do and why...Explain your process...

[excelvbanew]

i would like user to auto populate the text that added in the user form to the merge row originally and show the full value visible of what they written
as user arent able to write anything in the merge row
but issue due to merge row now

[Sintek]

why not populate below each other in separate rows...

[excelvbanew]

due to some straight business process currently is like this .............

[excelvbanew]

I have try to make it work however after realize that a limited height row for a row which is at 409 there
my vba i am able to successfully make it a new row when it exceed 409 however it didnt start from the hide cut value it start a new one again does anyone how to fix this ??
i did it directly the userform when the user click ok it will reformat my cells and do whatever it suppose to do

[Sintek]

Time to teach your boss how to do it the proper way...Merged cells causes havoc with excel vba...Gonna have issues all the time...