USING VBA EXCEL AND OPTION EXPLICIT

Youre having a dinner party. Youre inviting couples, their children, and dogs. Youre not sure who youll invite yet.

Write a program to work out how many place setting items you will need, depending on the number of adults, children, and dogs you invite.

Each adult gets a salad plate, a salad fork, a dinner plate, a dinner knife, a dinner fork, a dessert bowl, a dessert spoon, a water glass, a wine glass, and a napkin.

Each child gets a dinner plate, a dinner knife, a dinner fork, a dessert bowl, a dessert spoon, a water glass, and two napkins.

Each dog gets four napkins, a food bowl, a water bowl, and two dog treats.

An extra four napkins are added, as spares.

Compute totals, as in the following example:

Write everything in VBA. Do not use formulas in the worksheet.

1 Adults: 2 Children: 3 Dogs 7 Dinner plates: 8 Salad plates: 9 Dessert bowls: 10 Total dishware: 11 12 Dinner knives: 13 Dinner forks: 14 Salad forks: 15 Dessert spoons: 16 Total flatware: 17 18 Water glasses: 19 Wine glasses: 20 Total glassware: 21 22 Napkins: 23 24 Water bowls: 25 Food bowls: 26 Dog treats: 27 Total dogware: 28 29 Grand total: 6 3 2 Run 9 6 9 24 9 9 6 9 33 9 6 15 24 2 2 4 8 104