Is it possible to run a macro while I am typing in a cell

Is it possible to run a macro while I am typing in a cell ,

Suppose I am typing in A1,I am typing the word Sourav,and whenever this string has 6 characters at that very moment I want to run a macro.

I did it with worksheet_change event,but in that case I have to type an enter or tab to get away from A1,and then that macro will run


So what if I want to do this without typing enter or tab,means the macro will run while I am still in A1

Is it possible.

Thank You

Sourav Bhattacharya

What do you want that macro to do? Is this some sort of spell check or something?

Sorry for being late,what I wanted to do is find some data using a macro when the number of characters in the cell reaches 6,thank for the help

This forum is really helpful.

My god,this is what I needed,however the code is little bit complex,anybody know any book to learn api coding,

But thank you so so so very much for spending your valuable time on this,

I am very grateful for this.


Thank you

Sourav Bhattacharya

However even if I don't understand all the code,I have managed to run the macro on my criteria,how amazing is this,again thank you so very much


Sourav Bhattacharya

how do you guys got so good in excel coding,is it just experience, or some deeply buried knowledge treasure in internet.

Please enlighten me

But thanks again,this is really astonishing for me..

Sourav