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
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