ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Concatenate Textbx(s) Content HELP (https://www.excelbanter.com/excel-programming/312390-re-concatenate-textbx-s-content-help.html)

nrage21[_74_]

Concatenate Textbx(s) Content HELP
 

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


Tom Ogilvy

Concatenate Textbx(s) Content HELP
 
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





All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com