Hello,
I wish to double click on one of the Listboxes. When double-click I wish to add a new row with a text e.g. Rose. I tried both Double-box and then cellClick
Basically, implement a DoubleClick event (Insert New Event).
Add a Row,
Add whatever text from whatever source (Clipboard, File from disk, constant/variable) into the Cell you want.
I do not know what you want to do. Read the Listbox Control definition in the LR and use the correct way to achieve your goal.
In this case, you may want to edit a Cell, if so:
Add a brand new Row on a Click Event (to be added) or DoubleClick Event,
Set the cliked Cell as Active,
Type there what you want, once done, press the Return key (or Tab if you implemented it in your Listbox (to go to the next Cell and make it Editable.
Use the CellType or ColumnType properties to change a cell or column to “inline editable” when you want the user to be able to edit the contents of the ListBox. Then call the EditCell method for each cell. This gives the focus to the editable cell and selects the current text of the cell, if any. Typing replaces the cell’s contents. When the user presses Tab or Return or clicks in another cell, the cell loses the focus and the contents of the cell are saved.
The following code in the CellClick event makes the cell the user clicked on editable. The parameters row, and column are passed to the function.
Me.CellType(row, column) = ListBox.TypeEditable
Me.EditCell(row, column)
When a cell is editable, the ActiveCell property is the TextField that contains the contents of that cell. You can use this property to set or get the text of the Listbox cell, set the selection, or change other properties of the ListBox’s TextField.[/code]