excel text box

Hi ,
I want to format a cell so I can allow users to enter text in it( so firstly it should look like a textbox with a page turn kind of look at the right bottom corner) but it cant be a textbox because I will have an excel formula in it and then adjust the size of the text box(without changing the font size) according to the text entered. So for example, in a column if I have two text boxes (one below the other, each being 3 rows high), if the user enters 4 sentences in the first text box as oppose to 2 sentences in the second, the text boxes size should adjust and the first one should be 4 rows high and the second one should be 2 rows high.

Please helpppp

If you enter text in a cell it will overwrite whatever formula was there.

Format the cells to wrap text and the row height will autofit as long as it's not merged with another cell.