I'm still trying to figure out how to move data from a textbox in a userform to a textbox on the worksheet (created from picture toolbar). I manually recorded the following macro to see what code excel wanted. I've put this into my userform code and it runs without errors. Problem is, the textbox remains empty.
Private Sub CommandButton2_Click()
MsgBox ("Please load letterhead paper into the printer. Press OK when ready.")
ActiveSheet.Shapes("Text Box 239").Select
Selection.Characters.Text = TextBox10.Text
End Sub
Private Sub CommandButton2_Click()
MsgBox ("Please load letterhead paper into the printer. Press OK when ready.")
ActiveSheet.Shapes("Text Box 239").Select
Selection.Characters.Text = TextBox10.Text
End Sub