Excel VBA search facility

Hi guys

I’m using VBA in excel to find a particular product.

At the minute I have it working by searching text string in a textbox control and the macor finds the product after you hit a “search” button.

Ideally I’d like to be able to further automate this so that that it would search automatically after you select “enter” (carriage return) on the keyboard in the textbox

Can this be done?

Any help much appreciated

Thanks,