Auto increasing cell height based on ActiveX form textbox input

[HomeTek]

Morning,


I have a spreadsheet in which I have inserted a textbox, so that data input is easier for the user (similar to writing in Word).


I have set a default size for the textbox, but if the user enters more text than the current default height of the textbox then the text at the top becomes hidden. (See screen prints).


Is there a way around this at all? Perhaps a way to make the cell's height auto increase when a user enters a large amount of text?


Many thanks