Excel Programming - Code for searching a value from 1 cell in comma delimited multiple values in cell

hi

can anyone help me with how to search a value which is present in a cell inside a cell in another sheet. The cell where the single value is to be searched, there are multiple values with comma delimiter. For example in one sheet in one cell there is a value "hello" and in another sheet in one cell there are many values like "abc, hello, xyz, ghy, bye, etc" all comma delimited.

How do I search "hello" in "abc, hello, xyz, ghy, bye, etc" in vba?

thanks in advance