List Info

Thread: How to add function?




How to add function?
user name
2006-09-27 19:31:23
Have a look here:
h
ttp://www.mvps.org/dmcritchie/excel/getstarted.htm

-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Harmeet
Singh
Sent: Wednesday, September 27, 2006 2:14 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: How to add function?


Hi Everybody,

I wanted to add a function wherein i can convert a number
(amount) to 
words. I received the code for the same from a friend of
mine but he does
 
not know how to install it (somebody installed it for him).
Few lines of 

the function are given below. Can anybody explain how to add
it (i tried 

putting the lines in macros screen, but that does not work)

Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
    Dim Dollarss,centss , Temp
    Dim DecimalPlace, Count
    ReDim Place(9) As String
    Place(2) = " Thousand "
    Place(3) = " Million "
    Place(4) = " Billion "
    Place(5) = " Trillion "


Regards,
Harmeet

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )