+ Reply to Thread
Results 1 to 5 of 5

Trying to copy selected items from sheet to listbox then selected back to sheet

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    Wyoming
    MS-Off Ver
    Excel 2007
    Posts
    3

    Trying to copy selected items from sheet to listbox then selected back to sheet

    Thanks for being here, and I have searched through as many of the threads as I could to find my solution without seeing my particular problem. I may have overlooked it. If I have, I'm sorry.

    It's been a LONG time since I have done any programming, and since Excel supports neither COBOL or FORTRAN, I'm kinda stuck (yeah, I'm THAT old).

    I have a spreadsheet with items for sale, and I display them (on a form) in a listbox with checkbox controls (that was the easy part). The listbox is populated from the main sheet, I have no problems selecting or de-selecting.

    I would like a potential buyer to be able to select items from the listbox, and then copy those selected items into a different sheet, or a different range of the main sheet so that it can be printed.

    I think if I just knew how to reference those selected items, it would help, though I'm pretty sure I am thoroughly lost.

    ANY help would be appreciated.

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: Trying to copy selected items from sheet to listbox then selected back to sheet

    Do those listbox selections populate cells on the first sheet? If so just point the cells where you need the data on the second sheet to the address of the cells on the first sheet. If that doesn't work post a sample file so we can see what you want to do.
    Tom S.
    ↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the left
    If your question is resolved, mark it SOLVED using the thread tools.

  3. #3
    Registered User
    Join Date
    03-13-2013
    Location
    Wyoming
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Trying to copy selected items from sheet to listbox then selected back to sheet

    Quote Originally Posted by Tank997 View Post
    Do those listbox selections populate cells on the first sheet? If so just point the cells where you need the data on the second sheet to the address of the cells on the first sheet. If that doesn't work post a sample file so we can see what you want to do.
    Not quite. The first sheet is just a list of comic books (8000 or so) for sale, with prices and grade. When a buyer opens the form, the ListBox is populated from column A of the main sheet (that part goes flawlessly). The user then makes his selections from that list box (that also works just fine). When he clicks "Okay" (or whatever), I want to put his selections (from the ListBox) into a new sheet, starting at Column A, Row 1 (this is the part I'm having trouble with. I just haven't been able to figure out how to reference those things selected in the ListBox, and copy from the ListBox to the new sheet).

    Then I print the new sheet/list and give it to a picker who goes and pulls the selections from my inventory.

  4. #4
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: Trying to copy selected items from sheet to listbox then selected back to sheet

    BigWest, is the listbox on the sheet or on a popup VBA user form? Either way within you will need to set to Linkcell for to output the selection. If it's an on sheet box it's fairly simple to setup if it's a userform box you need to do some VBA code to set it up. There and many good sites on the web that explain the details of setting up the user forms and I'm sure you can search here and find many posts about the topic. I have also seen several YouTube videos on the topic so you might want to search there as well.

    Hope this helps.

  5. #5
    Registered User
    Join Date
    03-13-2013
    Location
    Wyoming
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Trying to copy selected items from sheet to listbox then selected back to sheet

    I think I've got it now.

    Thanks for the help!

+ 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