How Can I Colour Individual Text in a Text String with VBA?

  • Do you want to analyse what people say about your product on Amazon Marketplace?

• Or the reviews that people leave on your Facebook page?

Not a problem!

You can do some basic sentiment analysis with VBA!

As an example, I’ll be analysing 1000 fine food reviews posted on Amazon. Since I am mostly interested in the very positive and the very negative ones, I’ll be using the code below to loop through each review and highlight in green the words I’ve identified as positive and in red the ones I’ve identified as negative.

That way, I can then easily determine if the general perception of my product is mostly positive or negative.

And voila!

You can download the full spreadsheet here – 1000 Amazon Fine Food Reviews

Happy VBA coding!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.