onKeyPress in office macro

[InnerUK]

I am a fairly competent programmer but new to writing office macros and have just been set a task.

What I need to perform is capturing the keypresses in word/excel etc., apply a little logic and either accept and show the key pressed or perform an alternative action.

In the VBE brought up from office 2003 I have a list of document properties but there don't seem to be any events (such as KeyPress) that I can use to trigger my functions.

Am I missing something or is this kind of thing simply not possible in office macros?

Regards,

Mark

 

[SkipVought]

Mark,

Welcome to Tek-Tips.

This is not the forum for addressing code issues.

If you are planning to use VBA, please post in Forum707.

If you are planning to use VB 5 or 6, please post in Forum222.

FYI, VBA has no sheet-related or document-related keystroke events.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}