Hi all,

I've got a userform with a listbox. In the properties, I've selected
the row source & it works as expected. My problem is when I delete an
item out of the middle of that list, the listbow shows a blank space
instead of skipping it. I've looked at all of the properties & there
doesn't seem to be one that works on this, so I tried assigning the row
source range in VBE, but I kept getting a message that the object was
already in another module.

Does anyone have an efficient way to fix this?

Thanks


--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=396117