Results 1 to 7 of 7

vba excel - last listbox item transfer erasing all listbox items except last item

Threaded View

terriertrip vba excel - last listbox item... 11-02-2017, 08:08 PM
Norie Re: vba excel - last listbox... 11-02-2017, 08:21 PM
terriertrip Re: vba excel - last listbox... 11-03-2017, 09:07 AM
terriertrip Re: vba excel - last listbox... 11-03-2017, 03:30 PM
6StringJazzer Re: vba excel - last listbox... 11-04-2017, 10:56 AM
6StringJazzer Re: vba excel - last listbox... 11-04-2017, 11:10 AM
terriertrip Re: vba excel - last listbox... 11-06-2017, 03:48 PM
  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    vba excel - last listbox item transfer erasing all listbox items except last item

    I have 2 adjacent listboxes that I transfer items back and forth between. Everything transfers properly between them from the first item down until the last item. But if I select the last item to transfer in either ListBox, the item transfers to its adjacent list, however the rest of its originating list disappears. I've attached a sample workbook so that you can see what I'm talking about. Also ListBox1 actually has more code associated with it that fills from a lookuplist, so that is why there is so much odd coding regarding the ListBox1 fill routine.
    Attached Files Attached Files
    Last edited by terriertrip; 11-03-2017 at 05:10 PM. Reason: the last item, not the second to last item

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA To populate listbox with duplicate item by increasing the item quantity
    By Sintek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2016, 07:51 AM
  2. [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
  3. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  4. [SOLVED] Items in Userform Listbox are wider than list box. Need to see all character of item
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2012, 06:40 AM
  5. How to number listbox items, enable a cmd button and move item lines?
    By Kimberley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2011, 09:10 AM
  6. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  7. Transfer Item From Range1 to Range2 Using ListBox
    By hifliers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2009, 06:13 AM

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