Printing text from a textbox in a userform using vba code
i don't think you can just print the value.
you have to transfer the value onto a worksheet
and then print that.
Zigball wrote:
This is my example of trying to get the userform to print the value of
textbox2
Private Sub CommandButton2_Click()
UserForm1.texbox2.Text.PrintOut Copies:=1, Collate:=True
End Sub
Private Sub CommandButton2_Click()
Range("A1").Value = textbox2.Value
ActiveWorksheet.PrintOut
End Sub
xxxxxxxxxxxxxxxxxxxx
susan
|