Extending the character limit of a textbox

Hello!

I am attempting to input a textbox into my excel sheet that I am hoping will serve as a template and work with the macro button function (new to this so my lingo is likely off). However, my textbox will only allow me to input a certain number of characters. Is there a way to increase this character limit so I can display all 3 of my paragraphs together without having to create another textbox? For example this is an idea of what I currently have (I took out the actual text though):

Private Sub TextBox1_Change()
TextBox1.MultiLine = True



TextBox1.Text = "Rather long paragraph of text " + Range("A1") + "more text" + vbNewLine + vbNewLine + "even more text"


End Sub

My end goal is to have excel ranges where users can input scores and those scores are then updated in the textbox and users can simply copy/paste the contents of the textbox to satisfy reporting requirements. I don't want to have to export the data to word using paste special or anything because I want this to be a stand alone application.

Any help is appreciated,
Thanks

I have multiline set to true and it still won't allow it....I may be so new to this that I am missing something very obvious...if you look at the above code example, does the TextBox1.MultiLine=True not satisfy that requirement?

I am not referring to the UserForm, an ActiveX textbox. I cannot find the multi line option in properties (excel 2016).

This worked wonderfully, thank you.