Question: can someone help me with this problem in vba excel. im having trouble understanding it. Homework Due: Write out on Paper, then type code into

 can someone help me with this problem in vba excel. imcan someone help me with this problem in vba excel. im having trouble understanding it.

Homework Due: Write out on Paper, then type code into VBA. Submit both (one on moodle, one at classtime). I Write a VBA module/program/code (with a unique subroutine name) that a) Has your program read 2 numbers 3 numbers from an EXCEL spreadsheet. b) Use both the RANGE and CELLS commands at least once. c) One number will be a integer, one will be a single variable, d) Your EXCEL spreadsheet has 1 cell that has the units. You e) Your program then adds the 3 numbers and displays the and create a constant variable = 100 CONSTANT, one an INTEGER and one a single variable. read that into your program as a string variable. answer and units in a message box and also on the spreadsheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!