Auto-complete / Suggested Search

Hi All,

I would appreciate your help. I want to create a search function on a UserForm with an Auto-complete / Suggested record function. This is what I would like:

• Search field that searches column "A" for a unique identifier (GUID);
• As you type the alpha-numeric characters into the search field, it lists suggestions of records that match that section you have typed. I.e., when you type "1" it lists all the records starting with "1", when you type another character, it lists the records matching those first 2 characters etc.;
• When you have found a match, you can select the record to edit it in a UserForm before saving the record;
• If you do not find a match, you can create a new record;

Thank you in advance!