Parsing a vba's variables data

[warren_s]

Hi
I have 4 variables with words in them for example

one="dog"
two="cat"
three="bug"
four="bird"

I have a 5th variable with a sentence in it for example

Sen=”The bug and bird are in the park”

What I need to know is which of the variables content appears in the variable Sen first and what position it is. In this case it would be variable three position 5.

Does anyone have an idea how to do this in VBA, I would appreciate your suggestions.
Thank you very much in advance.
Warren

 

[warren_s]

That works perfect, thank you all so much.