+ Reply to Thread
Results 1 to 2 of 2

Moving all columns from listbox 1 to listbox 2 and see all details of an selected item

  1. #1
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    Exclamation Moving all columns from listbox 1 to listbox 2 and see all details of an selected item

    Hey Guys,

    I have 2 listboxes : The first one is populated with everything i need from the worksheet.
    The second listbox is for the user to see what items did he selected in order to be "transfered."

    The problem that i face :
    1)I can't move all data available on different columns, except the 1st one that contains the row id.

    There are 4 options :
    - move all to list 2 (button sign >>)
    - move selected to list 2 (button sign >)
    - move selected to list 1 (button sign <)
    - move all back to list 1 (button sign <<)

    Note when the user selects an item from list 1 and wants it to move to list 2 he must input a number that will appear in the last column (input box) -> done

    2) When the user would transfer them back, the last column should not be...transfered. (related to the first one)

    3) There is a button "info about selected" that should display everything from all the columns selected , but if nothing is selected, should display a message like "nothing selected" -> this results in an error. Works for listview , but not for listboxes ?

    Side questions :
    - (for easy noting 3.1)The button from the problem 3 can auto detect witch list is selected and the unselect the item after displaying the infos? or should i try 2 buttons for 2 listboxes ?
    - (for easy noting 3.2) Mini-Bug? if using the second option - move selected to list 2 (button sign >) on the last item selected , the entire list is cleared . This does not happen if i select any other item from the list. It's something that i miss?

    Thank you for your time and patience
    I have attached a demo file and a picture with the code idea .
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by alexgoaga; 11-05-2018 at 12:17 PM. Reason: Added info

  2. #2
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    Re: Moving all columns from listbox 1 to listbox 2 and see all details of an selected item

    Fixed, changed all the forms to ListView4 and remade the entire code.

+ 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 selected item un-highlights when moving to another pat of the form
    By Happytab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2018, 04:24 AM
  2. vba excel - last listbox item transfer erasing all listbox items except last item
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2017, 03:48 PM
  3. [SOLVED] Do something for each selected item in a listbox
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2017, 06:38 AM
  4. Get the name of a listbox where an item is selected
    By Jerbinator in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-22-2016, 03:16 PM
  5. Listbox item Highlighted but not Selected
    By shawnvw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2015, 05:29 PM
  6. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  7. Selected item in first listbox.
    By waka in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-09-2015, 11:45 PM

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