printing a receipt from excel

[vbanewbie2]

is there also a way to have the data listed within the spreedsheet go to a ticket or receipt (that looks just like the userform) in case the user needs to print it out? Just curious and looking for extra credit... I don't think anybody else would think about that one

[Guido Geurs]

Example for setting data to a form: (see attachment)

Private Sub CMDshowLabel_Click()
   UserForm1.TextBoxDate.Text = Range("A1").Value
   UserForm1.TextBoxName.Text = Range("B1").Value
   UserForm1.Show
End Sub

For printing the form, use:

Private Sub CMDprint_Click()
   UserForm1.printform
End Sub

[vbanewbie2]

what if its based on a name? the user has all these rows of information each row containing a different name how would that get printed out.

UserForm1.TextBoxDate.Text = txtname.value
 

[Guido Geurs]

We have send You only the principle, how it can work.
If You want to go to the details, please attach an example of Your sheet and an example of what You really want (if possible) in BYTES or give a clear description so we can go directly to the point.