+ Reply to Thread
Results 1 to 4 of 4

Excel UserForm Transfer of data to Columns

  1. #1
    Registered User
    Join Date
    05-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel UserForm Transfer of data to Columns

    I have managed to put together some code that will based on the selection for the user form transfer the data to a sheet.

    However, I would like the data to transfer the data and move to the next column, so if the user selects the button add the data is added to a column and each time the add button is selected then it will move to the next column and paste the data. Right now it just over writes the existing data in the column

    Here is the code I have so far.... just need to to get to move to the next column.

    Please Login or Register  to view this content.
    Last edited by davesexcel; 12-19-2012 at 11:26 PM. Reason: You are Canadian, come on man.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: Excel UserForm Transfer of data to Columns

    Attach a sample workbook.

    When you are in Advanced reply, click on the paperclip to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    05-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel UserForm Transfer of data to Columns

    I have tried many times to upload my file however I keep getting an error.... I will continue to try as I truely need help!

  4. #4
    Registered User
    Join Date
    05-11-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel UserForm Transfer of data to Columns

    Create Segment.xlsm

    Attached is my sample file when the user clicks the button a form will appear and the user can create by selecting the names for a segment, each time the user clicks add it should transfer the selection to the sheet and move to the next column so that the user if need be can continue creating segments without over riding the one created.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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