How would you create a For Loop that activates within a cell in Excel?

Question

How would you create a For Loop that loops within a specific cell?  I want to make a code that loops for each 'word' (separated by spaces) within a cell.  So if a cell contains the string 'the dog has fleas', I want my code to activate on 'the', then on 'dog, then on 'has' and finally on 'fleas' before stopping.

Puzzler-S · Accepted Answer

the worksheet on change event is the only thing i can think of using. But i don't know how you could do any kind of activation on a cell while someone is typing in the values, just when its completed.

How would you create a For Loop that activates within a cell in Excel?

Related Questions

Trending Questions