Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

FINA0404A/3351A FALL 2017 Assignment 1 (Due by 11:59pm, October 2, 2017) Download Excel file HW1.xism and finish all the problem sets in it. Submit your

image text in transcribed
image text in transcribed
FINA0404A/3351A FALL 2017 Assignment 1 (Due by 11:59pm, October 2, 2017) Download Excel file "HW1.xism" and finish all the problem sets in it. Submit your Excel file to the "Assignment1" session on Moodle. 1. (Input and Message box) Create a new module in VBE named "Q1". Then create a sub called RevenueCalc that does the followings: (1) It asks the user for the unit price of some product and stores it in the variable unitPrice, defined as Currency type; (2) it asks the user for the number of items sold and stores it in the variable quantitySold, defined as Integer type; (3) it calculates the revenue from this product and stores it in the variable revenue, defined as Currency type; (4) it displays a message such as "The revenue from this product is $380." Input boxes and the message box should look like this: (In the message box, "$40" should be the result based on the inputs from the first two boxes.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course in Quantitative Finance

Authors: Thomas Mazzoni

1st edition

9781108411431, 978-1108419574

More Books

Students also viewed these Finance questions

Question

What is a social role? (p. 30)

Answered: 1 week ago