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

Any help will be greatly appreciated!!

- Larry -
VBA Amateu

--
nrage2
-----------------------------------------------------------------------
nrage21's Profile: http://www.excelforum.com/member.php...nfo&userid=480
View this thread: http://www.excelforum.com/showthread.php?threadid=26611

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