Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Change Event
Hello,
Is there a way to have an event fire as soon as a user starts typing data into a cell range? IE: I can use the worksheet_Change event but it only fires after the user presses the enter key. A form level control change event fires once we start changing the data... This is what I want on a worksheet... Any Ideas? Thanks, Ernst. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Change Event
I don't have an exact answer... but if it were me I'd look for function/code
that is something like on_focus that way as soon as the cell has cursor focus the event will fire...just a thought "Ernst Guckel" wrote: Hello, Is there a way to have an event fire as soon as a user starts typing data into a cell range? IE: I can use the worksheet_Change event but it only fires after the user presses the enter key. A form level control change event fires once we start changing the data... This is what I want on a worksheet... Any Ideas? Thanks, Ernst. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Change Event
for all practical purposes, macros don't run while a user is editing a cell.
So there are no built in events that fire on each key entry while editing a cell. -- Regards, Tom Ogilvy "Ernst Guckel" wrote in message ... Hello, Is there a way to have an event fire as soon as a user starts typing data into a cell range? IE: I can use the worksheet_Change event but it only fires after the user presses the enter key. A form level control change event fires once we start changing the data... This is what I want on a worksheet... Any Ideas? Thanks, Ernst. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Change Event
I think I know what your trying to do. The closest way That I found is
creating a form and aligning one ch size textbox in a line to appear as one textbox and formating each box to one chr. keep tab order proper and code a search from first chr then from two chr and so on untill match or a new entry is required in list. Good luck. "Ernst Guckel" wrote: Hello, Is there a way to have an event fire as soon as a user starts typing data into a cell range? IE: I can use the worksheet_Change event but it only fires after the user presses the enter key. A form level control change event fires once we start changing the data... This is what I want on a worksheet... Any Ideas? Thanks, Ernst. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell value change event | Excel Worksheet Functions | |||
Cell change event | Excel Programming | |||
CELL CHANGE EVENT | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Cell Change Event | Excel Programming |