Please refer the attached Excel file.

Requirement - The pop up form should allow only that much text to be input that can be seen with max row height. Please note that cell width is not be altered.

Also see there is a code to adjust row height of the cell as per the text max upto 409 points.

Is there any other way to input multiline text in a cell in the same way as we enter in a Word document ?

This is just a sample document. In the real time scenario there are other cells and data following the highlighted cell. So, that has to be kept in mind as well in case you are thinking of splitting the text down in other cells if all text is not visible.