Key press event in VBA Excel

Posted by Nishithraj under Others on 2/3/2010 | Views : 18176 | Status : [Member] | Replies : 1
How can we get key press event in excel VBA.

Requirement: In a cell while typing itself the code needs to be invoked and it has to check the length of the total character typed. If it is more than 900 characters it should restrict key press with a message(you have reached the limit of the maximum no characters).

Any idea?

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan


Posted by: Bubbly on: 2/4/2010 [Member] Bronze


You can check this link

Hope it helps

Thanks & Regards,

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response