Assuming the text boxes are numbered in the same order that you listed them,
you could:

Private Sub UserForm_Click()
ActiveSheet.Range("A1") = Me.TextBox2,Value & "," & _
Me.TextBox1.Value & "-" & Me.TextBox3.Value
End Sub

But I would seriously consider putting the employee number in a separate
column for sorting, searching, etc. at a later date if needed.



"Pats" wrote in message
...
My userform has a TextBox for First Name , Last Name and Employee #. What
I
need to know is, how can I put the contents of all 3 Textboxes into one
cell?

Example:

Last Name, First Name - Employee #