vsto excel keypress event

i am working on a vsto excel project, and i want to capture keypress, and keydown events on the worksheet.

i have tried globalKeyboardHook

but it gives exception, please any one have a solution, please provide guidance in right direction.

i want to capture the cell contents and provide auto suggest feature based on the conte开发者_StackOverflownts, as the user types in the cell.

thank you in advance.

You can easily achieve it using the GetAsyncKeyState() WinAPI function, but it would be a bad practice if you need a solid application that needs to work on different environments.