I've created two listboxes. My objective with the following code is to add listbox1 item to listbox2 when listbox1 item is selected. Then i would like to remove the selected item from listbox1. But i receive an error that i don't understand, and the code that Excel highlights in yellow (indicating a problem) is: ListBox1.RemoveItem r
There error message reads:
"Run-time error '-2147467259 (80004005)':
Unspecified error."
Please Login or Register to view this content.
Last edited by Wedge120; 09-18-2016 at 01:18 PM.
You cannot remove an item while it is selected. Add this line before your RemoveItem:
Please Login or Register to view this content.
That was the problem..thank you.
With this new line of code, two items from Listbox1 are being copied to Listbox2: the item selected and the item just below it. After stepping through the code, i realized it was executing twice with the item just below the original item being selected after removing the first.
This is triggering the Listbox1_Click event a second time? Should i be using the ListBox1_Change event? Not sure what to do here.
I discovered that using the "DblClick" event evades the problem i am having.
Sorry, I should have thought of that. The general strategy for dealing with this kind of thing, where you do something in your code that will trigger an event, is to use a variable to indicate whether or not the code should respond to the event. Something like this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks