Good morning! I have a question about using arrays. Please excuse my ignorance (and noobness - LOL) as I've only just started learning vba in the past couple of weeks and my programming experience is (very) minimal. I'm learning fast, but there's a lot to learn when starting from the ground up!

My question is: Is it possible to assign a list of keywords to an array, then do a sub to search through a paragraph of text in a cell and tell you how many of the words in that array are contained in that cell?

Thank you for your time and I hope y'all have a great day!