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

Something like this?

Please Login or Register  to view this content.

Great Mr. jolivanes
What about small letters .. I want to get the same results if I typed (yass) for example ...?

Other method

Please Login or Register  to view this content.

thanks Mr. Jindon for this simple and effective code ..
Just a point it returns the value itself .. I want to return the address of the value

How do you want it?

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Thanks a lot Mr. Jindon
You are very helpful
I'm learning a lot from you my tutor