Text boxes, user forms and command button help needed

**brewsi** · 05-11-2014, 02:22 PM

hi guys,

this is my first post and i really hope one of you lovely people can help me.
Ok here's my dilemma.

I have created a userform with multiple text boxes in it. The idea is that an individual will populate these text boxes with the appropriate information. they would then click a command button that would copy all text boxes in order and with spacing onto one text box on a second userfom to allow all the information to be copied and pasted into a different programme. i have built both userforms and the command button. the problem i am having is writing the VBA to copy more than one textbox and with spacing. at the moment when i submit the iformation by pressing the command button it only copies one text box data or all data without spacing.

so does anyone know the correct VBA to copy multiple text boxes onto one text box keeping the spacing ?

Thank you so much in advance for your help

**6StringJazzer** · 05-11-2014, 02:50 PM

What do you mean by "spacing"--"with spacing", "without spacing", "keeping the spacing"?

I would think it would be something as simple as

textbox1 = textbox2 & vbCrLF & textbox3

**brewsi** · 05-11-2014, 04:06 PM

hi jazzer,

thanks for responding so fast.

by spacing i mean the spacing between the text boxes. E.g

userform 1 Text box1 .....Data in entered here....

Text box2 .....Data in entered here...

Text box3 .....Data in entered here....

command button clicked

Userform 2 Textbook 1 ....Data in entered here...

....Data in entered here...

....Data in entered here...

so you see the position of the text boxes on userform one is retained in userform 2 text box 1

hope this makes things clearer

Again thanks in advance

**6StringJazzer** · 05-11-2014, 04:24 PM

If the sample line of code I posted doesn't help you then attach your file.

Do you have code in place to try to do what you want, even if it doesn't work?

**brewsi** · 05-11-2014, 04:32 PM

thanks jazzer

much appreciated. its actually a work project so ill try it tomorrow. How would i use the code for multiple text boxes

textbox1 = textbox2 & vbCrLF & textbox3

would i need to put

textbox1 = textbox2 & vbCrLF & textbox3 & vbCrLF & textbox & vbCrLF & textbox5

or would it just be

textbox1 = textbox2 & vbCrLF & textbox3& textbox4& textbox5& textbox6 and so on ?

Sorry if that sounds like a silly question i only starting teaching myself excel at the end of April so still quite new to the code.

Thanks again

**6StringJazzer** · 05-11-2014, 04:41 PM

vbCrLf is a special character that means Carriage Return and Line Feed. It forces a line break in the middle of your text, so yes, you need to repeat it in between every pair of textboxes.

**brewsi** · 05-11-2014, 04:42 PM

perfect

thanks so much. ill let you know how it goes

Text boxes, user forms and command button help needed

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Text boxes, user forms and command button help needed

Re: Text boxes, user forms and command button help needed

Re: Text boxes, user forms and command button help needed

Re: Text boxes, user forms and command button help needed

Re: Text boxes, user forms and command button help needed

Re: Text boxes, user forms and command button help needed

Re: Text boxes, user forms and command button help needed

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help to create Command Button with text boxes input

User Forms Basics - Text Boxes to Named Range

Help needed! How use a Command Button to pop up a text box in Excel?

Entering data into two text boxes using one command button

[SOLVED] User Forms - Command Button defines value to be used later

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions