Cell Selected
 
Notifications
Clear all

Cell Selected

5 Posts
2 Users
0 Likes
1,870 Views
0
Topic starter

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

 

 

dpiti0815 Topic starter April 23, 2020 5:03 am

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?

dpiti0815 Topic starter April 23, 2020 5:16 am

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
Topic starter

Thank you Jim,

that works perfect

Best

Dimitri

0
Topic starter

Thank you Jim,

that works perfect

Best

Dimitri