Is there a MySQL % (approximation) equivalent in VBA?

I'm a newbie when it comes to all types of coding. Recently I've learned that if you want to look for a record with a specific value inside you can use % eg. %PHP% - looks for any record with the word PHP in it, regardless of what stands before or after it.

I want to do the same thing in VBA. I want VBA to look through a cell and determine whether the word "XXX" appears anywhere in it. If yes I want VBA to change the entire cell to the word "YYY".

Can anyone help me with this? Please, keep it simple since I'm quite new to this.