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!
Bookmarks