Yes you can create your own functions using VBA. They are called UDF (User
Defined Functions.) An example that I just created (which could be done
using a formula, but for demonstration purposes) is :

Function CountCharacters(myVar As String, myChar As String) As Integer
Dim i As Integer, l As Integer, cnt As Integer
Dim testChar As String

cnt = 0
l = Len(myVar)
For i = 1 To l
testChar = Mid(myVar, i, 1)
If testChar = myChar Then
cnt = cnt + 1
End If
Next i
CountCharacters = cnt
End Function

Which I created in a Module (not in a workbook or worksheet event.)
Then I used the following formula in my worksheet:
=countcharacters(B7,",")
B7 contained : 1,2,3,4,5
and the result of the function was 4.

If you are interested in VBA there are plenty of books or web sites that can
get you started. Also, check out the programming forum.
--
Kevin Vaughn


"anthropomorfic" wrote:


HI

I ever like to know if there is a way to create my own functions, (ex:
the distance between two coordinates of points in space).

if there is a way I'll be happy if someone can tell me how

:)

bye and tvm


--
anthropomorfic
------------------------------------------------------------------------
anthropomorfic's Profile: http://www.excelforum.com/member.php...o&userid=31382
View this thread: http://www.excelforum.com/showthread...hreadid=510788