Listbox: detect selection of non editable cell by arrow keys, not by click

Hi, I’m struggeling with the the list box.

The Problem:

  • The CellGotFocus Event does fire only when editable cells get the focus
  • The CellClick event does only fire when I click on a cell
    But how do I detect if a non editable cell gets the focus without clicking on it? For example by using the arrow keys up and down?

Thanks for any Help


KeyDown Event / Chr(9) for Tab will help you.

Not knowing what you want to do do not allow many guesses on what you need.

Look at the ListBox bottom examples (LR) cor coor change.

Thanks, I managed it by using ListBox1.SelectedRowIndex within the KeyUp-Event.