I'm not sure if the title is the right way to address the question, but anyway,
The user of my userform pastes a block of data into it. I've managed to correctly copy the data from the form so far into a single cell, but I want the data to paste so that it appears as though the user right-clicked and expanded it into numerous cells.
Exists a way to accomplish this? Bad explanation, I know; for clarification, view the screenshots.
Private Sub IPButton2_Click()
Dim text As String
text = TextBoxIPData.text
Range("D1").Value = text
Form: Form Image
What I'm looking for: Right Click, Intended Result
What it's doing: Form Result
I have tried different ways to express the data and have it input, but it all ends up stuck in one cell.