Cells

[Jengo]

How do you delete a cell from a listbox?

 

[CharlesDFW]

Hmm. If I understand your question, I don't think you really can. A listbox is more like a database table than a spreadsheet. It consists of rows determined by the rowsource. When it initializes, it gets from its rowsource the rows to use, and that's what's going to be there for the user to choose from.<br><br>You can control what rows go in, and you can control what columns go in and which of these columns are visible. But you can't pick one particular row/column intersection and manipulate it directly in the listbox. You have to manipulate it in the rowsource and refresh your listbox.<br><br>If what you're asking is how to make a column invisible, this is done by putting in the number of columns you want from your rowsource (a datatable, query, or recordset of some kind) then adjusting the width of the columns. If you want the column invisible, set width to zero.<br><br>Hope this answers what you're asking.<br><br>Charles<br>