-
I see, when you mentioned a form, I thought you meant a UserForm, but you're working with an Activex component. (that would have been woth mentioning at the start, btw)
So some more questions:
Where does the code break on the error?
Have you tried to select any items in the listbox after you run the code? Because ScreenUpdating has been switched off, it may not be refreshing
K :-)

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules