Tabbing through columns in a listbox

General
1

Is there a way to make is so when a uses presses the tab key the cursor moves to cell to the right of the cell being currently edited like in a spreadsheet?

2

You have to code that yourself using the events.

-Karen

3

I have tried but have not been successful. Does anyone have instructions on how to do this?

4

in the cellaction event of the listbox

me.editcell( nextcellrow, nextcellcolumn)

you have to calculate what is the next available editable cell for your listbox of course.
something like

    nextcolumn = column+1
    if nextcolumn>me.columncount then 
    nextcolumn=1
    nextrow=nextrow+1
    end if
5

Thanks, I’ll give that a try.