+ Reply to Thread
Results 1 to 5 of 5

copy over data from userform to sheet2

Hybrid View

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    copy over data from userform to sheet2

    Dear sir,
    i want to copy date from userform to sheet2 to find their columns and put below in same row
    ignore blue cells .....
    Attached Files Attached Files
    Last edited by mak_pj; 12-24-2013 at 01:25 PM.

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: copy over data from userform to sheet2

    Hi mak_pj

    I'm trying to figure out what Data Fields go where...what is ID? Is it a Free Form Field that's simply entered by the User?

    Can you have multiple SAME Names/Creditors or Debtors in the SAME UserForm?
    Last edited by jaslake; 12-25-2013 at 07:48 PM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: copy over data from userform to sheet2

    Hi mak_pj

    I'm not certain about your requirements...try the Code in the attached. Please note, I've renumbered your ComboBoxes and TextBoxes.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: copy over data from userform to sheet2

    Hi Jaslake
    i'm happy to see your reply again your code working fantastic thank you very much

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: copy over data from userform to sheet2

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy over data from userform to worksheet
    By mak_pj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-09-2013, 03:42 PM
  2. [SOLVED] MultiSelect Listbox in Userform to copy data to worksheet
    By aarodn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2013, 03:52 PM
  3. [SOLVED] Copy Data loaded via Userform to a worksheet named in 1 field of the Userform
    By audax48 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2012, 01:44 PM
  4. Copy List of Userform Data to Worksheet
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-22-2011, 10:15 AM
  5. Copy/Paste from worksheet to textbox in userform
    By jarrods in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2009, 05:52 PM

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