Challenge: Simple Scrabble game in VBA

Hi Everyone,

Thank you for taking the time to view this. All answer and suggestions are greatly appreciated.
I was recently given a challenge and with my limited VBA skills, I can not code this. I can do this on regular spreadsheet the challenge is use as few cells as possible.

Problem: Match all letter with a specified numerical value. Then sum up the value of the word

Please refer to the Scrabble game official Point Values for all letters.

Example: g=2, o=1, d=2
the word "Good" would return a sum of 2+1+1+2=6 in the next cell

Requirement:
- Both input and output has to be displayed on Excel spreadsheet
- there will be multiple players
- Highlight winners with the highest points.

Thank you so much!

.
VBA version of Scrabble : http://www.dustinormond.com/blog/vba-scrabble/

Formula version of assigning number value to letter character :
https://superuser.com/questions/1357...value-in-excel

Converting letter character to its ASCII number :
https://stackoverflow.com/questions/...numbers-in-vba