Combining data in multiple textboxes
 

Good afternoon,

I have created a form that has multiple textboxes. I was wondering if
there is code that I could use to combine the data from the textboxes,
i.e. 1, 2, 3, and then have that entered into a cell on one of my
worksheets.

Any help would be appreciated!
Cheers,
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608
View this thread: http://www.excelforum.com/showthread...hreadid=527820

Combining data in multiple textboxes
 

Try something like

Range("A1").Value = Me.TextBox1.Text & Me.TextBox2.Text &
Me.TextBox3.Text


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"toocold"
wrote in message
...

Good afternoon,

I have created a form that has multiple textboxes. I was
wondering if
there is code that I could use to combine the data from the
textboxes,
i.e. 1, 2, 3, and then have that entered into a cell on one of
my
worksheets.

Any help would be appreciated!
Cheers,
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile:
http://www.excelforum.com/member.php...o&userid=31608
View this thread:
http://www.excelforum.com/showthread...hreadid=527820

Combining data in multiple textboxes
 

Thanks Chip, exactly what I was looking for

--
toocol
-----------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...fo&userid=3160
View this thread: http://www.excelforum.com/showthread.php?threadid=52782