Thanks for the reply.
I found an alternative way to solve this. Here is what I did.
1. I pulled all the list items from the drop down and stored into a String variable of array type using Split method.
2. I compared each of these list items with the text string I have using Instr method by adding a loop.
3. If found I then checked the position if it is greater than or equal to 1. And if true then select the list item with the count that matches in the loop statement.
I found an alternative way to solve this. Here is what I did.
1. I pulled all the list items from the drop down and stored into a String variable of array type using Split method.
2. I compared each of these list items with the text string I have using Instr method by adding a loop.
3. If found I then checked the position if it is greater than or equal to 1. And if true then select the list item with the count that matches in the loop statement.