printing out a textbox contents.

[medic5678]

I have rather large textbox where a user can type notes and use the return key for spacing, etc.

textbox1.value is (example)

1. Problem1. Solution is blah blah blah.

2. Problem 2. Solution is blah blaha blah.

3.etc

4.etc

5.etc



The question is how I can parse this line by line to my worksheet so I can print it out with Excel? I would just expand a cell height to contain the whole note *but* it cannot handle the enter keys this is spaced with. Am I overlooking a very basic, easy way to do this?

 

[medic5678]

I've inserted a textbox to my Excel file, textbox1. The question is *how* to copy the contents of my userformtextbox to the one in the worksheet.

 

[medic5678]

rivate Sub CommandButton3_Click()
Dim tb As Shape
Set tb = Sheet1.Shapes("TextBox 1")
tb.TextFrame.Characters.Text = ShiftNoteTBX.Value


End Sub

Turned out to be amazingly easy. Wow, this is one POWERFUL program.