I am using the following code to paste a text box into a cell and it is working fine, but I would like the text broken out into multiple cells rather than all in 1 cell. How can I change the code to do that?
For example, the text box has data like this (all in 1 text box named Text Box 13):
Explanation:
A: input explanation here
B: input explanation here
C: input explanation here
All of this data is currently being copied to cell AE2, however, I would like to have "Explanation" in cell AE2, "A: input explanation here" in cell AE3, "B: input explanation here" in cell AE4, etc.
Dim txBox As Shape
Set txBox = ActiveSheet.Shapes("Text Box 13")
Range("AE2").Value = txBox.TextFrame.Characters.Text
Thank you all in advance!
For example, the text box has data like this (all in 1 text box named Text Box 13):
Explanation:
A: input explanation here
B: input explanation here
C: input explanation here
All of this data is currently being copied to cell AE2, however, I would like to have "Explanation" in cell AE2, "A: input explanation here" in cell AE3, "B: input explanation here" in cell AE4, etc.
Dim txBox As Shape
Set txBox = ActiveSheet.Shapes("Text Box 13")
Range("AE2").Value = txBox.TextFrame.Characters.Text
Thank you all in advance!