Blank spaces in a listbox

S

Soundman

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
 
J

Jim Rech

Did you delete a row or merely clear the cell? You must do the former.
Also, be sure to assign a name to the list range and use the name as a
RowSource. A cell address Rowsource like A1:A10 will not adjust if you
delete a row in it, whereas a named range will.

--
Jim
message |
| 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?action=getinfo&userid=24428
| View this thread: http://www.excelforum.com/showthread.php?threadid=396117
|
 
Top