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. 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
Get step-by-step solutions from verified subject matter experts
