+ Reply to Thread
Results 1 to 8 of 8

Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

  1. 03-13-2013, 01:10 PM #1
    Excelnoub
    Excelnoub is offline
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    Good evening everyone,
    I would need help in this, tried to search but not getting what I need.

    I have a Cmd button on my Sheet1 that does the following:

    Please Login or Register  to view this content.
    My userform1 is a listbox1 that has info from my sheet2 in Cells A3 to A1000.

    In my Sheet2 I have DataForm that is from column A to column N.

    I need that when I select my cmd button from sheet1 to open the userform1 (listbox1) that when I double click on a selection to search in my Sheet2 vs the row that matches the title and to copy that selection (so from A to N on sheet2) then to copy and paste the information (by transposing itself) in sheet1 A7.

    I also need help if I select multiple selection from the UserForm1 (listbox) to skip a row when the second batch of information is copied and pasted.

    I have attached my workbook with better explanation.

    Please help thank you.


    Integrity Check.xlsm
    Last edited by arlu1201; 03-13-2013 at 02:32 PM.
    Reply With QuoteRegister To Reply
  2. 03-13-2013, 01:58 PM #2
    Excelnoub
    Excelnoub is offline
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    I had a code that worked well if you needed a msgbox to popup but that is not the case...

    Please Login or Register  to view this content.
    But I want to change it to search then Copy/paste/transpose in Sheet1 A7.
    Reply With QuoteRegister To Reply
  3. 03-13-2013, 02:22 PM #3
    Excelnoub
    Excelnoub is offline
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    Almost have it I think playing around....

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-13-2013, 03:34 PM #4
    jaslake
    jaslake is offline
    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: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    Hi Excelnoub

    Try the Code in the attached...
    Attached Files Attached Files
    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.
    Reply With QuoteRegister To Reply
  5. 03-14-2013, 07:50 AM #5
    Excelnoub
    Excelnoub is offline
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    jaslake it is perfect. Just one small thing that I will need to find...

    UserForm1 Error: If no selection is made,

    Please Login or Register  to view this content.
    If I add a 
    Please Login or Register  to view this content.
    it loops on the error and you have to close excel.

    Then after everytime a selection is made error return on the following line: 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 03-14-2013, 08:59 AM #6
    jaslake
    jaslake is offline
    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: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    Hi Excelnoub

    Replace the entire UserForm1 Code with this 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-14-2013, 09:05 AM #7
    Excelnoub
    Excelnoub is offline
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    Awsome man thank you so much
    Reply With QuoteRegister To Reply
  8. 03-14-2013, 09:49 AM #8
    jaslake
    jaslake is offline
    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: Cmd to Listbox (Find info in sheet2) copy/paste info to A7 Excel 2007

    You're welcome...glad I could help. Thanks for the Rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1