Results 1 to 7 of 7

Text boxes, user forms and command button help needed

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2014
    MS-Off Ver
    Excel 2003
    Posts
    36

    Text boxes, user forms and command button help needed

    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
    Last edited by brewsi; 05-11-2014 at 02:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help to create Command Button with text boxes input
    By pasj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2013, 12:07 PM
  2. User Forms Basics - Text Boxes to Named Range
    By T.J. Lanza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2009, 03:35 PM
  3. Help needed! How use a Command Button to pop up a text box in Excel?
    By matt@career-horizons.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 02:05 PM
  4. Entering data into two text boxes using one command button
    By Charlie Chalk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2006, 11:00 AM
  5. [SOLVED] User Forms - Command Button defines value to be used later
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2006, 06:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1