cigarette wrote:

Dear all, would appreciate if anyone can help me with this

I know nuts about excel, not to mention its vba programming.

I am trying to write a program using excel to calculate geometrical
properties of any arbitrary shape, namely perimeter, enclosed area
etc...I have several queries about how to start, listed as below :

1) the user to draw the shape required, either by autoshapes or any
other means, but the important thing is that i need the program to
capture the points that the user has clicked, for reference as
co-ordinate points. From here i can do vector calculus to work out the
perimeter, using the function { INTEGRAL F(r) dr}(*ignore this
function if not sure*). But how do i program it (vba)?

2) Subsequently using the points captured i need to perform various
integrations again to obtain the other properties. The Main problem is
how to get the program to perform integration? Bear in mind that some
of these calculations includes double integrals.

I know that this may be tough if you do not have mathematics
knowledge, but i will greatly appreciate if anyone can help with the
2 problems listed. That is, (1) how to capture the points, (2) perform
mathematical integration. :(

Please try to help me, thanks in advance


---
Message posted from http://www.ExcelForum.com/

For the autoshapes: use the .Nodes property of a Shape object. This
gives you a ShapeNodes collection.
The .Points property of a Node gives you the coordinates.
More info in Excel/VBA help.

For the integrals: http://www.cheresources.com/integrals_in_excel.shtml
You can google others using the following keywords: excel vba integrals

--
To top-post is human, to bottom-post and snip is sublime.