fire macro on any keystroke? 1

[butchkmd]

I have a spreadsheet that I am using a macro to move to the next cell if len(text)= 1. I have not found a way yet to fire the macro with every keystorke. I tried the worsheet change event but you have to press enter for it to work.

Any suggestions would be greatly appreciated

Matt

 

[Dreamboat]

Hi Matt. Methinks you are going about this form business the wrong way, and I cannot keep my mouth shut any more. I have never been known to be able to do it at all!

If you're inclined, why don't you email one of these things to me so I can see if I can help you out REALLY FAST. I'm home all day. I know time is at a minimum for you--or at least I think you indicated as much.

I promise confidentiality.

Dreamboat@TheWordExpert.com

http://www.TheWordExpert.com