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