Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedcan 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

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

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions