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
These are all text boxes on a user form? In the code for the command button, try:
HTH,Code:Textbox5 = Textbox1 & vbCrLf & Textbox2 & ", " & Textbox3 & " " & Textbox4
Jason
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
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks