Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How would you create a For Loop that activates within a cell in Excel?
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.
1 Answer
- Puzzler-SLv 51 decade agoFavorite 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.
