Textbox data to cell
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
|