ActiveCell.Value = Userform1.Textbox1.Value & _
Userform1.TextBox2.Value

--
Regards,
Tom Ogilvy

"nrage21" wrote in message
...

I've been searching this site and other unsuccessfully for vba code that
will allow me to concatenate content in textbox1 and textbox 2 into "a
single cell" in a worksheet. Can someone please write a line that would
do what I require? Do I need to use the "&" sign?

Any help will be greatly appreciated!!

- Larry -
VBA Amateur


--
nrage21
------------------------------------------------------------------------
nrage21's Profile:
http://www.excelforum.com/member.php...fo&userid=4808
View this thread: http://www.excelforum.com/showthread...hreadid=266112