+ Reply to Thread
Results 1 to 8 of 8

problem with listbox output to another listbox

  1. #1
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    problem with listbox output to another listbox

    I have the following code which populates listbox1 depending on the selections made in three comboboxes.

    I then need the user to select one of the options from listbox1 which then drops into listbox2 for output later...

    At the moment I am struggling with the code to send the data from listbox1 into listbox2 correctly...perhaps its because it's late or i've no had enough coffee!!

    Entries in listbox1 can be sent without highlighting them, and where "england", "london", "road #3" is selected the user needs to be able to select both options from listbox1...at the moment only the bottom row moves across.

    Can someone please have a look and amend if possible... I'm sure what I have done already is as inefficient as hell!!!

    Thank you,

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: problem with listbox output to another listbox

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

  3. #3
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: problem with listbox output to another listbox

    I'm sorry I don't get it???

  4. #4
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: problem with listbox output to another listbox

    Workbook attached...
    Attached Files Attached Files

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: problem with listbox output to another listbox

    I reckon
    Please Login or Register  to view this content.
    ought to be
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  6. #6
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: problem with listbox output to another listbox

    Ha ha...success!! Nice one...but I still have one little query,

    Why is it the items in listbox1 are ALL moving on the button click even though they are not selected!

    It the user is presented with a choice of two or more options in listbox1 they need to be able to select one in listbox1 and that is the only one that will move to listbox2.

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: problem with listbox output to another listbox

    because this line
    Please Login or Register  to view this content.
    selects each item rather than testing if it has been selected. perhaps you intended
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: problem with listbox output to another listbox

    Brilliant...thank you ever so much....yet another invaluable lesson learned.

+ 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