Write a macro in excel

Have a table with customer data. You need to write a macro:

- Run a macro that opens a search bar
- After entering in a search string of digits, the macro looks for the corresponding value in column a
- After finding in column a of the corresponding Zn