Limit word count inside a cell

[Red_Blues]

Hello everyone,

I am writing sentences (9000 of them) within a given word count guideline ( min 9 and max 17 ) and I am looking for a way to somehow set up an alert ( change writing color, pull a flag,etc ) if the word count within each cell falls below or goes above.
Not great with excel I must admit, but I am confident there is a way.

If someone out there has an idea, would be fantastic.

Thank you so much

 

[johnnyL]

The problem you face is that while entering characters into a cell, you can't run any vba/macro code.

You can trigger a code to run upon selecting a cell or pressing enter in a cell, but no code can be ran as each character is entered into a cell because you are in 'Edit Mode' when you are entering characters into a cell, thus no code can be executed during that time.

 

[johnnyL]

About the closest I can think of to obtaining your goal is to set it up so when you click on a cell, you could have it indicate, via color, if the number of words are within the accepted amount, for example red text for outside the accepted amount of words and green text if it is within the accepted amount of words.

 

[bebo021999]

My thinking, not test (never done before)
Use Key_press (KeyAscii) even to catch spacebar even, then count
if Keyascii=32 then
count=count+1
If count<7, text font colour "red"
If count>7 and <17: black (or green)
>17: turns red again

 

[johnnyL]

I refer you back to post #2.