Question: Write a VisualBasic code for macros in Excel , that calculates A + B and A x B, where A and B are two-dimensional arrays.

Write a VisualBasic code for macros in Excel, that calculates A + B and A x B, where A and B are two-dimensional arrays. (Do not use the Excel spreadsheet functions to calculate A + B or A x B. User For Next loops to perform the operations.) In writing the code, consider the following.

Ask the users whether they want to use the data given below to test the code or use their own data. If the users choose to read the data from the table, copy this data in two two-dimensional arrays A and B. Otherwise, ask the users to enter the size of each array and the corresponding elements.

Ask the users whether they want to perform the A + B or A x B operation. Prompt the users if the size of the arrays is not suitable for the chose operation.

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 General Management Questions!

Need Help ASAP!!!! Thank you!!! AP Java FRQ: Gradebook Directions: SHOW ALL YOUR WORK. REMEMBER THAT PROGRAM SEGMENTS ARE TO BE WRITTEN IN Java. Notes: Assume that the classes listed in the Quick...

This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and Querying in Excel...

INTRODUCTION This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and...

CSS - HW: Arrays You will write a program that calculates the velocity of a skydiver as a function of time. The main program will include a loop that allows you to enter in the specifications for...

'a. Using the properties window in the VB editor assign the code name wsEx2 to the sheet with tab name Sheet1. 'b. Using VBA code and the code name for worksheet Sheet1, make this worksheet the...

You will write a program that calculates the velocity of a skydiver as a function of time. The main program will include a loop that allows you to enter in the specifications for more than one jump....

Restrictions: You cannot import any Java classes except those listed below. In particular, you cannot use any methods from the Java Array(s) class to copy an array, check for equality, or otherwise...

Using VBA, create a sub. Please also print screen the code so I know easier to read intention. Worksheet 'Data' contains information about some US colleges and their college football rankings. Answer...

Programming Language is MATLAB. OILA Proportional Integral Derivative PD coller is a closed-loop controller that is normally used in many industrial application Forumple, a PID controller can be used...

use excel Problem #3: In a previous assignment, Excel wrote a Macro for you by recording your actions. The language the Macro was written in was Visual Basic, or VBA. You can use VBA to program...

Why is it often difficult to obtain competent and meaningful user involvement in the SDLC?

The press shown is used to emboss a small seal at E. Knowing that P = 60 lb, determine (a) The vertical component of the force exerted on the seal, (b) The reaction at A. 10 in. P. 5 in. 20- 60

. Sunland Company is performing a post - audit of a project completed one year ago. The initial estimates were that the project would cost $ 2 2 9 , 0 0 0 , would have a useful life of 9 years, zero...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...