Question: VBA CODE Write a VBA (Visual Basic for Applications) sub program to verify whether a point (with x and y coordinates) lies within a specified

VBA CODE

Write a VBA (Visual Basic for Applications) sub program to verify whether a point (with x and y coordinates) lies within a specified irregular polygon.

- The irregular polygon must be described by a series of coordinates connected by straight lines.

- Make sure the point declared in such a way that the lines connecting two adjacent points do not intersect.

VBA CODE Write a VBA (Visual Basic for Applications) sub program to

Specific Requirements: The program should allow the user to:

Define a polygon with a maximum of 8 edges. (Use the inputbox function to prompt the user to insert number of edges as well as the coordinates of the polygon.)

Define a maximum of 20 points to evaluate whether each point lies inside or outside the area.

I know there are many ways to write code to achieve the same result, but keep the coding as simplistic if possible! Thank you :)

verify whether a point (with x and y coordinates) lies within aspecified irregular polygon. - The irregular polygon must be described by aseries of coordinates connected by straight lines. - Make sure the pointhere's to make it more clear + a solution template added

yright left yc left t (TA Tleft Tright left yright left yc left t (TA Tleft Tright left

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 Databases Questions!