Notifications
Clear all

Cell Selected  

   RSS

0

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?

Topic Tags
3 Answers
0

SelectedCells() is not writeable but I could change that...

You can use me.selected(5,5)=true

0

Thank you Jim,

that works perfect

Best

Dimitri

0

Thank you Jim,

that works perfect

Best

Dimitri

Share: