Sentiment Value of Text

[Ehtisham Ali]

Hi All,

It is long time I am writing.

I have found a code online to calculate sentiment value of a text. I want to enhance it's functionality with "Spell Checker" and "Grammar Checker".

And display the count of errors. Please refer attached sheet for more clarification.

Thanks in advanced

 

[NARAYANK991]

Hi ,

A Spell Checker is more a dictionary checker , since nothing more is required , unless the dictionary is only going to store the root word , and other modified words will need to be checked within the code.

A Grammar checker is a very ambitious project , and I doubt there will be too many of them in the public domain.

Narayan

 

[NARAYANK991]

Hi ,

See the following :

http://dailydoseofexcel.com/archives/2004/10/19/checking-grammar/

https://stackoverflow.com/questions/40158997/macro-to-be-able-to-check-for-grammar-in-workbook

The second link aptly illustrates the danger of thinking that VBA can do everything !

Narayan