UserForm - Text Box Code (Whatever Text Has Been Entered Into The Userform To Be Put Into Multiple Default Cells)

[tdownwa]

I've created a userform with a text box and a command button (Enter)

On clicking the command button I'd like whatever text (mutiple lines of text copied from a .doc) that has been entered into the userform to be put into a cells starting with A1 and thru the row if applicable or down the column if applicable.

I thought using: Sheet1.Range("$A$1:$P:300").Value = Me.TextBox1.Value might work but that pastes all the data from the userform into every cell listed in that range.

I then tried Sheet1.Range("A1").Value = Me.TextBox1.Value thinking that might work but that only puts the data in a specfic cell.

Maybe I shouldnt be trying to force it as a Range...

Below is a screen shots examples of what I'm trying to get accomplished. Oh and one last thing... the size of the data continually changes. its not always the size shown below.

Thanks in advance!

 

[tdownwa]

I figured this out on my own... please close.

answer = Sheet1.Range("A1").PasteSpecial Paste:=xlPasteFormulasAndNumberFormats = Me.TextBox1.Value