| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA triggers on tabkey
On Apr 19, 1:03*pm, "Clif McIrvin" wrote:
"jt" wrote in message ... On Apr 18, 5:00 pm, Gord Dibben wrote: You have a sheet_change event. Something has to be changed or edited in a target cell. Are you typing in the cell then hitting the Tab Key to exit? Should fire your event. If you don't type or edit something in the cell Tabbing out will fire nothing. Hitting ENTER key will not fire your event if you do not change or edit the cell contents. D-click then Tab or ENTER will fire the event. F2 then Tab or ENTER will fire the event. Picking from a Dropdown list will fire the event. Gord Dibben MS Excel MVP On Mon, 18 Apr 2011 13:26:37 -0700 (PDT), jt wrote: but it doesn't fire when I hit the tab key?- Hide quoted text - - Show quoted text - I am typing in the cell then hitting the tab key and the event does not fire, but i guess i will have to just hit enter all the time, thanks for your help ------- Is there something like * *Application.OnKey "{TAB}", "TabProc" anywhere? *It wouldn't even have to be in the workbook you are working on ... if any code traps a keystroke that trap overrides the normal behavior until code turns the trap off. Do you have any addins installed? -- Clif McIrvin (clare reads his mail with moe, nomail feeds the bit bucket :-)- Hide quoted text - - Show quoted text - not that I'm aware of... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to activate triggers in Excel | Setting up and Configuration of Excel | |||
| help! trouble with triggers... | Excel Programming | |||
| Macro that triggers off a combo box | Excel Discussion (Misc queries) | |||
| Event Triggers | Excel Programming | |||
| Triggers events | Excel Programming | |||
Threaded Mode
