I'm very new to Excel VBA and creating forms, does anyone have an example of something similar, or perhaps point me toward a tutorial?
I need some help creating a form that will do the following:
ask how many people? 3
what are their names?
person 1: john
person 2: paul
person 3: george
how many apples will they consume?
john: 96
paul: 192
george: 10
The apple containers can hold 48 apples each. I need the output redirected to a text file that will assign each apple to a specific place in the containers from largest amount to smallest such that:
pauls' apples will take up the first block of container spaces: 1/1 thru 4/48
johns' apples will take up the next block of container spaces 5/1 thru 6/48
georges' apples will take up the last block of container spaces 7/1 thru 7/10
thank you!
I need some help creating a form that will do the following:
ask how many people? 3
what are their names?
person 1: john
person 2: paul
person 3: george
how many apples will they consume?
john: 96
paul: 192
george: 10
The apple containers can hold 48 apples each. I need the output redirected to a text file that will assign each apple to a specific place in the containers from largest amount to smallest such that:
pauls' apples will take up the first block of container spaces: 1/1 thru 4/48
johns' apples will take up the next block of container spaces 5/1 thru 6/48
georges' apples will take up the last block of container spaces 7/1 thru 7/10
thank you!
