Write a vba module that has your program read 3 numbers

Assignment Help Computer Engineering

Reference no: EM132217396

Question :

Write a VBA module that has your program read 3 numbers from an excel spread sheet, etc. Can someone please show me in detail what to do.

Write out on Paper, then type code into VBA. Submit both.

Write a VBA module/program/code (with a unique subroutine name) that a) Has your program read 3 numbers from an EXCEL spreadsheet.

b) Use both the RANGE and CELLS commands at least once.

c) One number will be a CONSTANT, one an INTEGER and one single variable.

d) Your EXCEL spreadsheet has 1 cell that has the units. You read that into your program as a string variable.

e) Your program then adds the 3 numbers and displays the answer and units in a message box and also on the spreadsheet.

Reference no: EM132217396

Questions Cloud

Write a function that will take an integer nasan input : Write a function that will take an integer nasan input and return then-thnumberin the Fibonacci sequence using recursion.

Performance appraisal after spending several weeks on job : Carter Cleaning Company The Performance Appraisal After spending several weeks on the job, Is Jennifer right about the need to evaluate the workers formally?

Determine the smallest and largest element of the array : Find the sum and the average of the elements in the array. Determine the smallest and largest element of the array.

Employee empowerment can have plenty of good benefits : Employee Empowerment can have plenty of good benefits for the organization if managed and implemented correctly

Write a vba module that has your program read 3 numbers : Write a VBA module that has your program read 3 numbers from an excel spread sheet, etc. Can someone please show me in detail what to do.

Amateurs and professionals resolved in north american sports : How was the conflict between amateurs and professionals resolved in north american sports? how was this same conflict resolved in england?

Employees covered on new not necessarily non-profit model : What could this mean for the employees covered on this new "not necessarily non-profit" model?

Disadvantages of using blockchain technology in retailing : What are the advantages and disadvantages of using blockchain technology in retailing?

Develop strategy for reducing the burden of heart disease : Develop a strategy for reducing the burden of heart disease in your state and present it as a visual using a logic model.

User Account

All Pages