VBA Forms search and update

Hi team,

I work with the accounts payables team wherein we receive invoices on a daily basis from external service providers and we need to track the incoming invoices and update the status as and when it gets processed.

In order to track them I have built an excel form which helps in updating the invoices into excel as and when we receive it.

However as and when we complete the processing we need to update the status of these invoices. Is there anyway we can have a search utility built in the form which can use the Invoice Number(unique ID) for populating all the details in the form and provide an option for updating the status.

I am attaching the Invoice tracker for your reference.

If anyone can help me with the code for searching and Updating the already inserted invoice data, it will help me in floating this into production. Please let me know if you need any more information.

Thanks a ton for your assistance in advance.

Regards,
Raghu