+ Reply to Thread
Results 1 to 13 of 13

Listbox Multiselect transfers to worksheet

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Listbox Multiselect transfers to worksheet

    I have a Listbox with Multiselect turned on with a rowsource to a named range. There are 5 text choices that feed an 'if' equation on the spreadsheet . I want each of the 5 text choices to link to a particular cell and fill the cell in if selected or leave the cell blank if not selected. Let's just say it's A1:A5.

    I have found a lot of possibilities on the web but nothing is working so I'm starting from scratch...this is what I have so far:

    Please Login or Register  to view this content.
    I told you I was starting from scracth! Did you think I was kidding!!!??? :D :D

    Any advice?

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Listbox Multiselect transfers to worksheet

    Submit your workbook

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    I can't due to company policy....but here's a made up example. Thanks

    Sample.XLSB

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Listbox Multiselect transfers to worksheet

    Please Login or Register  to view this content.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Listbox Multiselect transfers to worksheet

    Perhaps.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  6. #6
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    Your code worked perfectly in my sample the way I want it to work...then I moved it over to my real spreadsheet and I messed something up.

    So here's my whole change event code (with your part added in). I'm using cells AN3:AN7 and there's other stuff below AN7 that I don't want changed/impacted by the code. I have several worksheets that could be active so I thought I needed to add the "sheets" before the ranges.

    What am I doing wrong?

    Please Login or Register  to view this content.
    Thank you for all your help, advice, and expertise!

  7. #7
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    I'm a novice in case you can't tell by my code. So any other advice you have on the other code would be appreciated as well!

  8. #8
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Listbox Multiselect transfers to worksheet

    You didn't read what I wrote.

    'I made an assumption that column E will be used in your real book as you have it in your example workbook. If not then this won't work.
    Try Nories suggestion. It should work without having column E
    Last edited by stnkynts; 01-08-2015 at 05:08 PM.

  9. #9
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    I did read what you wrote....so I changed "E" stuff to "AN" stuff!

    I will try Nories.

  10. #10
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Listbox Multiselect transfers to worksheet

    Did you try the code I posted?

  11. #11
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    NORIE! IT WORKED PERFECT!
    SYNKYNTS - I had not thought of clearing the ranges and now see I needed to do that in MULTIPLE places throughout my code as I was getting false results because of left over code.

    So thank you both so much!!!!!!!

  12. #12
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    Ok....same issue I've just hit another roadblock. I need the same thing done however, I need the data placed in columns I:M in the next blank row. Currently to insert my data, this is what I use:

    Please Login or Register  to view this content.
    For the part you helped me with I did this:

    Please Login or Register  to view this content.
    So now instead of sheet named "Validation" and range AN3:AN7, I want to use:
    sheet named "SkinData" and range I:M (it's 5 choices in the listbox) in the next blank row (as data is continually added to this spreadsheet.

    Do I need to start a new thread for this? Thanks again!

  13. #13
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Listbox Multiselect transfers to worksheet

    Hi! Anyone that could help with this would be great! See above!

+ 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. Listbox MultiSelect to find/copy/paste rows to new worksheet in VBA
    By rsm555 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2014, 10:19 AM
  2. Listbox To and From Array Data Transfers
    By Eebigdog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2013, 04:41 PM
  3. [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
  4. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  5. Click on userform transfers to listbox below
    By Deutz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2012, 02:41 AM

Tags for this Thread

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