VBA Sentiment Analysis with rated words, positive word bank, negative word bank..?

Question

Has anyone tried or has guidance on creating a VBA Sentiment Analysis? I have a word bank of negative words/phrases and positive word bank. I made the word bank very specific because for example, I want "Technical Issues" to be a negative phrase it picks up to rate it negative and then sometimes people write "No Technical Issues" or something similar that I have in the Positive Word Bank that I would want to use to offset it to make sure it does not rate that feedback negative. Also, in my negative word bank, I have rated the words 1-5 on how negative they are. For example, the word "discrimination" would be a 5 since it is very negative and the word "concern" would be rated 2. Also, I want to be able to count negative words as well, so for example, if an entire feedback for one person has multiple negative words (that are each rated) I would want it to add it up so that that feedback would be rated higher as negative then a feedback that is negative, but only has one negative word so it would be rated lower than the feedback that has multiple negative words. Please let me know any guidance on how to go about this or if I am going on the wrong way about this.

Answer 1

There is an add-in to Microsoft Word, Windows, and Mac, called AuthorTec Find and Highlight. It operates from lists of words or phrases that you create, and it scans your documents for these words, telling you how many there are and each is highlighted. You might check it out as a starting point.

Full disclosure, I am the author of the add-in.