Clear keyboard buffer

[foxguy]

Is there any way to clear the keyboard buffer in Excel 2003?

I have a macro that takes a few seconds to execute, and users have a tendency to click another key because they don't think the first click was recognized, so I'd like to have a macro that throws away the extra click.

[Leith Ross]

Hello foxguy,

If you want to ignore the users typing or mouse clicks while the macro runs, you can do it this way. Copy this code into a Standard VBA module.

Please Login or Register  to view this content.

Your code would look something like this where "MyMacro" is the name of the macro you want to execute.

Please Login or Register  to view this content.

[foxguy]

Thanks Leith