ListBox.Cell Method

Used to read from or write to the cell based on the row and column numbers passed. Passing -1 as either the Row or Column number means all rows or all columns, respectively.

Syntax

ListBox.Cell RowNumber, ColumnNumber


Parameters

RowNumber

Integer

ColumnNumber

Integer


For example, the following specifies all columns in the next available row:

Me.cell( Me.lastindex, -1)

If you set this equal to a tab-delimited array, you can update the row with one line of code.