+ Reply to Thread
Results 1 to 6 of 6

Listbox1 items to move in Listbox2.

  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Listbox1 items to move in Listbox2.

    Hello,

    I have a workbook with Two Listbox.

    I just want when the user click the item in Listbox1, it will move to Listbox2.
    Appreciate your help.

    I've attached the workbook.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-24-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Listbox1 items to move in Listbox2.

    Try this...
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Re: Listbox1 items to move in Listbox2.

    Thanks moonsaga, but how can i remove the selected items from listbox1?

  4. #4
    Forum Contributor
    Join Date
    09-24-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Listbox1 items to move in Listbox2.

    Here is another way.. found on thread in this forum.. http://www.excelforum.com/excel-prog...m-listbox.html
    Please Login or Register  to view this content.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Listbox1 items to move in Listbox2.

    Try this code to replace the current ListBox1_Click

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  6. #6
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Re: Listbox1 items to move in Listbox2.

    Thanks All. Resolved!

+ 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. Adding/removing items - listbox1 and listbox2
    By yoko21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2013, 03:08 PM
  2. [SOLVED] Populate Listbox2 based on Listbox1 selection
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 09:04 AM
  3. Populate Listbox2 from Listbox1 selection
    By Macro1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2010, 07:06 AM
  4. [SOLVED] ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
    By SIGE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 12:06 PM
  5. Listbox1 to Listbox2?
    By Moretakitty in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-20-2005, 07:06 PM

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