On May 16, 2007, at 7:33 PM, Norman Palardy wrote: > On 16-May-07, at 8:17 PM, Tim Jones wrote: > >> HI Folks, >> >> I've finally come upon a use (within my environment) for editable >> cells in a listbox. The question is how do I know when the user has >> finished the edit? It seems that the CellTextChange event first >> [FIRES] on >> ANY change (while the user is typing), and the normal Change event >> fires just about anytime you look at a cell :-). >> >> What should I be watching for to know when the user has finished the >> edit and exited the field? > > Celltextchange is one
Like I said, fires with every keystroke... :-( > Also look at the activecell property as it's an editfield Fortunately, only one column is editable, so I only need to track the current row. However, I guess I could watch the Change event and if there is no ActiveCell, then I know they've finished... Not elegant, but it might work. > The only thing I've ever run into is that a person edits data and > does NOT press return or leave the last cell they edit so you never > get an event > You may need a "done timer" that you can trigger or some other meanss > to deal with this situation. Another reason for us to all be frustrated by the ListBox :-(. Well, Norman's stuck the knife in, anyone else want to give it a twist?? ;-) Tim -- Tim Jones [EMAIL PROTECTED] _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
