Hello, I am a new VBA programmer and need advice of all you for my very first excel VBA job required by my company.
There is a file with two sheets that as UserForm and Product (which contains data).
I am about to search value on Product by inputting by user at UserForm sheet. So that if the value match when clicking "Search" button then Goto the Range that matches value on Product.
But the matter is the Product code is designed of many types like "73521005-06-07"( the input searching must have not "-" and single, it is shorted by 73521005,73521006,73521007 )
The more detail in the file attached below. It drives me stuck. So i really need all your help for the first VBA. Thank you so so much.
Sample_searching.xlsx