Userform: Pass textbox values to another textbox on button press

adjustermn · #1 02-08-2010, 10:54 PM

I am trying to pass data entered in several textboxes on to display in another textbox as a string of text in the same userform on button click

Ex:
Textbox 1: 123456 E Main St
Textbox 2: Miami
Textbox 3: FL
Textboc 4: 33172

all data combined to:

Textbox 5: 123456 E Main St
Miami, FL 33172

All the data entered needs to be in a textbox combined as text so i can use the copy and paste button on all the data.

I would also like to have the textbox have linebreaks so each entry is formated like an address entry.

Thank you for the help in advance

jasoncw · #2 02-09-2010, 03:38 PM

These are all text boxes on a user form? In the code for the command button, try:

Code:

Textbox5 = Textbox1 & vbCrLf & Textbox2 & ", " & Textbox3 & " " & Textbox4

adjustermn · #3 02-09-2010, 03:52 PM

Thank you for your help I am still having problems getting this to work (and it's probably my error) I posted this code below in my command button and nothing happens when I click it. Do I need some kind of code in the box everything is combining in?

Private Sub txtFirstcontact_Click()
txtFirstcontact = txtlimita & vbCrLf & txtlimitb & ", " & txtlimitc & " " & txtlimitd

jasoncw · #4 02-09-2010, 10:19 PM

Are all 5 text boxes on the same user form? If so, that should work. Could you possibly post up a copy of the document?

Welcome to the Excel Forum

Forum Statistics