Question: I want to solve this with VBA code in Excel.Please help me. A total number of N points P; are defined in a plane by
I want to solve this with VBA code in Excel.Please help me.
A total number of N points P; are defined in a plane by means of their coordinates X; and Y. The number of the points and the values of their coordinates must be input from a text file with the following content: N X Y XN YN The input coordinate values must be output preliminarily on Sheet1 with precision of two digits after the decimal separator in the following way: Coordinates of points X X Y Y XN Y From the keyboard, the coordinates of one additional point T must be input. A matrix A[N,3] must be created, whose first column contains the distances from the points P to the origin of the coordinate system 0, whose second column contains the distances from the points P; to point T, and whose third column contains the surface areas of the triangles OTP;. The computation of the distances and of the areas must take place in sub- procedures. The matrix A must be output on Sheetl under the table of coordinate data in the following way: OP PiT OTPI The starting of the different sub-procedures must be done with command buttons
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
