Question
Using VBA Excel and Option Explicit You start a company selling Catbots, cute robotic cats. You have two models: Model Price Weight (kilos) Darth 1000
Using VBA Excel and Option Explicit
You start a company selling Catbots, cute robotic cats. You have two models:
Model | Price | Weight (kilos) |
Darth 1000 | $159 | 1.1 |
SayTen 44b | $299 | 1.9 |
Write a program to compute the price of an order. It reports shipping cost, and total cost. The program starts like this:
Customers enter the number of each bot they want. Check that the data is numeric, and between zero and five inclusive. Show an error message if the data is bad. For example:
Shipping cost depends on the order. Orders for $1,000 or more (excluding shipping) are shipped for free. Otherwise, shipping is $4 per kilo. For example:
Use the IPO pattern, that is, separate subs for input, processing, and output.
1 Catbots Order 3 How many of each do you want? 5 Darth 1000 6 Say Ten 45b Compute 10 Shipping 11 12 Total 1 Catbots Order 3 How many of each do you want? 5 Darth 1000 6 Say Ten 45b Compute 10 Shipping 11 12 TotalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started