Is there a way to determine the row and column of the ActiveCell?
So, you want to know what Row / Cell was clicked ?
Read there ListBox :
Determining which cell was double-clicked
The Cell is Editable, you know the Row,Cell
You want to save the Cell “live” ?
Sorry, I just checked a project where I have an Editable Cell and I do nothing like that there. In CellGotFocus, I remove the FocusRing/ Set a Mask Value, but nothing related to what you ask.
In the Debugger, you can watch the ActiveCell (a TextField) if you add a CellKeyDown Event and set a Breakpoint there. This May Help you…
Dim Edit_Cell As TextEdit Dim My_Row, My_Col As Integer Edit_Cell = Me.ActiveCell My_Row = Row My_Col = column Edit_Cell.SelStart = Len(Edit_Cell.Text) Edit_Cell.SelText = "Row, Column: " + Str(My_Row) + "," + Str(My_Col) + "."
This returns what you asked into the ActiveCell.
That's similar to what I do now, but I was looking to see if it was available directly. I end up having to use a global property to save the current row and column so I can access it in other events. Seems I can't override the ActiveCell to add these properties either.
“No” and “I do not understand”.
There are plenty Events that have X and Y, and some that do not have.
If you put a TextField (in the Cell) where the user click for Edit, in the TextField, there are Events that told you X and Y.
Make a Search in this Forum (yes not easy) for the specs.
Editable Listbox are the search words I had in mind to made that search.