Validate cell in excel VBA : I would like to add a word limit validation to the cells within a column. For example, I do not want someone to be able to enter more than 150 words. Is this possible? If so, how is this done? 

I have wrote a formula to count the words in the cell and tried to add data validation to the cell, however it does not work correctly. Therefore, I am hoping VBA can help me achieve this. 

Please help!

