help creating a vba macro to maximize profit

XYZ Company has a product (GreenWidgets) that is price sensitive. When the price of the product is $600, they will sell 50 GreenWidgets. They wish to know if they are maximizing profits at that price or if there is another price that will yield more profit. They believe that each $50 increase in price will result in one less GreenWidget being sold. How many GreenWidgets will be sold to maximize profit and what will that profit be?

Write a VBA program that prompts the user to enter:

a. the current product price that results in 50 GreenWidgets being sold.
b. the increase in price that results in one less GreenWidget being sold.
c. Your outputs should be the number of GreenWidgets sold to maximize profit and what the maximum profit at that number of sales would be.

Can this be done by writing a for loop?

Thanks!


Andres

Dude thank you so much!