I have a problem with selecting cells. E.g. I can manually select a cell with the mouse. Then the cell turns blue because it is selected.
If I try do do this via code (to turn out blue) it is not really possible.
E.g. in the CellKey Down I placed following code, to select the previous cell when pressing arrow left:
if key.asc = 28 then
if column -1 > 0 then
me.listindex = row
me.NavigateToNextCell(-1,0)
me.EditCell(row, column-1)
end if
end if
This works - and the previous cell will turn blue as it is selected.
But I am again in the cell and press ESC (key.asc = 27) it will stoppt edit mode which is OK but the cell will not be blue (selected).
So how can I select a cell via code? without being in edit mode but being selected?
With my best regards
Dimitri
I found out that it is not possible to catch the chr(27) in cell when being in edit mode, only in key up. Is there another option?
Problem is, that I do not know how to select a cell ?
me.selectedcells(... is not working or how do I write code to select the cells 5,5 ? so row=5 column=5 - any idea?
SelectedCells() is not writeable but I could change that...
You can use me.selected(5,5)=true
Thank you Jim,
that works perfect
Best
Dimitri
Thank you Jim,
that works perfect
Best
Dimitri