Parts of speech count

Re: Parts of speech count

1) What have you tried so far?
2) Can you upload a sample workbook with anything you have tried so far included?

Assuming you're yet to really try anything, consider this:

In order to determine the part(s) of speech for each word, you will need to have a list of each word you're looking for that identifies it and associates it with the appropriate part(s).
There is apparently no way of leveraging Word's grammar checker in VBA.
So, you have some options to consider. The first approach that occurs to me would be to have a table of all the words you're interested in, with columns for each part. You can flag each word in the appropriate column(s) - a simple X will suffice. Then you need some pretty simple VBA to search for the word in the list.

Have a go, and upload what you've achieved if you get stuck. I'm much more confident that you'll get help if you have a try first.

Re: Parts of speech count

This took longer than I thought, and it isn't perfect, but I think it will help.

Ii have:
1) Formatted the table on your dictionary sheet as a Table.
a) This means you have to insert row(s) when adding words to the longest list (in this case Nouns) to ensure all words are tested for.
b) Avoid gaps in the lists in teh dictionary - this will probably stop looking if it encounters a blank cell. (untested)
2) Named the new table "Dictionary"
3) Created a UDF (User Defined Function) to do the maths
4) Call the UDF from the worksheet cell formula

Note: With the provided dataset, this does not work, as it will not recognise the last word in a string if it ends with a punctuation mark. I know there's a clever way to "clean" strings of certain characters but it's almost 1am and I have been on this for what feels like 3 hours now... (Edit: it's late, I'm tired...)

Good luck.

Re: Parts of speech count

You're welcome.