ListBox.Cell

From Real Software Documentation

Jump to: navigation, search
Method
ListBox.Cell ( RowNumber as Integer, ColumnNumber as Integer ) As String

Used to read from or write to the cell based on the row and column numbers passed.

RowNumber and ColumnNumber are zero-based. The top-left cell is 0,0. Passing -1 as either the Row or Column number means all rows or all columns, respectively. For example, the following specifies all columns in the last row added using AddRow or InsertRow:

Me.Cell(Me.LastIndex, -1)

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

Examples

This example copies all cells from one ListBox into another:

ListBox2.Cell(-1,-1) = ListBox1.Cell(-1,-1)

The destination listbox will have the same number of rows and columns as the source. Header data is not transferred.

In this example, the following code populates a two-column ListBox with the names of the controls in the window and their indexes.

Dim i as Integer
For i = 0 to Self.ControlCount-1 //number of controls in window
ListBox1.AddRow Str(i) //first column
ListBox1.Cell(Listbox1.LastIndex,1)=Control(i).Name //second column
Next
Retrieved from "http://docs.realsoftware.com/index.php/ListBox.Cell"
Personal tools