![]() |
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 |
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