Question: Part 1 :give me a very simple vba code for this problem: Create a button to help users find out the total sales by year.

Part 1:give me a very simple vba code for this problem: 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 2: 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!