Results 1 to 8 of 8

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

Threaded View

  1. #1
    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:

    Private Sub CommandButton1_Click()
    UserForm1.Show
    End Sub
    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.

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