Click here for important information about Computing.net.

How To Set Up VBA Form In Excel To Input Food Order?

March 18, 2020 at 12:39:13
Specs: Windows 7,win 10
I have a list of ingredients that I would like to develop a user form in VBA to allow the customer to select from a series of ingredients then it calculates the price at the end once you hit Order. Once selected the user hits submit which calculates the total and gives a summary of the final order.

See More: How To Set Up VBA Form In Excel To Input Food Order?


#1
April 13, 2020 at 03:39:35
I think that first point is to draw the userform, a simple sketch on paper.

Then build its fields and buttons in VBA from that sketch.

Then post here the code you are using and it's not working so we can help.

Sounds like fairly simple math:
- if it's bananas, the price is X times the number of kilograms the customer wants
- if it's canned beef, the price is Y times the pieces the customer wants

You would store all prices in an array and then in the end when Order button is pressed the total price would be displayed.


Report •
Related Solutions


Ask Question