VBA listbox remove item unspecified error
postman2000 Student Points379Trophies1Posts101
On a userform, I have a listbox named "eList" containing Employee Names. When I click Name items, it updates both listboxes with information (using "AddItem"). Code
Run-time error '-2147467259 (80004005)': Sometimes it happens after going through several names, sometimes it happens when clicking the 2nd or 3rd name. It's only happening on the "List_eNotTrained" line though--the other line is fine--which has me really puzzled. I'm hoping someone else has run into this before and might know what's causing this random, unspecified error..... :confused: Thanks for any help or ideas you can provide! postman2000 Student Points379Trophies1Posts101
Re: Random "unspecified Error" On "listbox.clear" In the UserForm code, I'm launching a Module-level macro using the following code ("eList" is the listbox of names) when a list item is selected: Code
"ED_selName" is a module-level macro that contains the problem code: postman2000 Student Points379Trophies1Posts101
Re: Random Unspecified Error On Listbox Clear Method I figured it out. Andy Pope OzMVP (Roobarb) Likes Received1Points33,975Trophies2Posts11,304
Re: Random Unspecified Error On Listbox Clear Method Thanks for posting the solution. Just for information. [h4]Cheers S M C The Oracle [Expert Coder] Likes Received2Points12,130Trophies2Posts4,036
Re: Random Unspecified Error On Listbox Clear Method Hi pstiglich Welcome to Ozgrid. DO NOT hijack threads by posting your question in thread someone else started. Always start your own thread and, if needed, provide a link back to the other thread. Please state your problem in a new thread. Cheers, S M C Click To Read: How To Use Tags In Your Threads/Posts |