hi
opps. posted under the wrong post.
i read the op's request. i have a play form where i test stuff before
posting. when i came back, you had already posted with almost the same thing
i had. i had already did the work so i thought i would just toss in my 2
cents any way. but posted under your post instead of the op's. sorry. my bad.

Regards
FSt1

"Dave Peterson" wrote:

I don't understand the difference.

Do you not like variables or do you not like qualifying the ranges?

FSt1 wrote:

hi
this should do it. adjust ranges to suit.
Range("C5").Value = _
Me.TextBox2.Value & ", " & Me.TextBox1.Value & " - " & Me.TextBox3.Value

regards
FSt1

"Dave Peterson" wrote:

Dim SomeCell as range

Set somecell = activesheet.range("a1")
somecell.value _
= me.textbox2.value & ", " & me.textbox1.value & " - " & me.textbox3.value



Pats wrote:

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 #

--

Dave Peterson


--

Dave Peterson