Find part of the text in a range of cells

Hello everybody
I have some values (numbers and texts) in range("A1:A10")
I have a code that show me an inputbox to type a value in and according to the value if it is found the address will be put next to the cell ..
My request is to be able to find for example all the occurences of specific text (say I typed "Yass" then the code has to give me three addresses in B1 & B6 & B10 .In other words to search part of the text not the whole text