Hello,
First of all, the link you provide does not work (it returns an error). If I understand correctly the specifications, you will have one or more workbooks, each one including text at least in some cells, and you need to find out the top 10 keywords from either all cells, or the specified columns or the specified sheets. What it is not clear to me is if you want to have the VBA macros to decide which words will be considered, based on some criteria or if you will provide a list of keywords and the macros will find the top 10 relative to the provided ones keywords from the text.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA macros of almost any kind and difficulty level, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini