Use excel VBA to code a macro and button. Part a: Create a button to heThis sheet is labeled as "sales" and goes up to $361.$ Do in a separate workbook next to it labeled "macro"

Use excel VBA to code a macro and button.

Part a: Create a button to help users find out the total sales by year. When the button is clicked, users should be prompted to enter year that they want to find out and the program should show the total sales of that year in a message box.

Part $b$ : create another button to add to the function. If a user enters a year that does not exist in the data remind the user to input the right years in a message box. Otherwise show the total sales of that year in a message box.