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 geometrica
properties of any arbitrary shape, namely perimeter, enclosed are
etc...I have several queries about how to start, listed as below :
1) the user to draw the shape required, either by autoshapes or an
other means, but the important thing is that i need the program t
capture the points that the user has clicked, for reference a
co-ordinate points. From here i can do vector calculus to work out th
perimeter, using the function { INTEGRAL F(r) dr}(*ignore this functio
if not sure*). But how do i program it (vba)?
2) Subsequently using the points captured i need to perform variou
integrations again to obtain the other properties. The Main problem i
how to get the program to perform integration? Bear in mind that som
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 problem
listed. That is, (1) how to capture the points, (2) perfor
mathematical integration. :(
Please try to help me, thanks in advanc
--
Message posted from
http://www.ExcelForum.com