Recent content by onefootswill

OlcayM, your suggestion did the trick. The new code is: So with every iteration, you take the bottom item (index 0) out. I experimented a bit and that is how is seems to work. Each time you remove index 0, they all shuffle up one. Thanks.

I can confirm that it still fails on 6 when I change the For loop to: For intListRow = 0 To 10 It is really quite weird. The easy workaround is: But I am still intrigued as to why it fails on 6 with the RemoveItem approach.

Hi There, This is not a huge problem, but it has me intrigued. I am new to VBA and am experimenting with populating/depopulating listboxes using Value List as the Row Source Type. Here's the idea: When I click the Empty Listbox button, i get the following error: The code for that button...