Rick,

Thanks so much!! I removed the module completely and recreated it and it
worked this time.

Thanks again!

rekfish

"Rick Rothstein (MVP - VB)" wrote:

It works for me. You did put all the code in a Module, not a UserForm or
Sheet code window, right? If you are not sure, you get a Module by clicking
Insert/Module from the VB editor's menu bar. UDFs must be placed in a
regular Module (not a Class Module) in order to work.

Rick


"rekfish" wrote in message
...
Rick,

I corrected the vb module with all info. I now get a name #name? error?

Thanks
rekfish

"Rick Rothstein (MVP - VB)" wrote:

It sounds like you only copied the SpellNumber function and not the other
3
helper functions located under it on that webpage... you need to copy
*all*
the code shown there into your code window.

Rick


"rekfish" wrote in message
...
I need to convert dollar value to english word, 100.21 to one hundred
and
twenty one cents. I have tried the vb module from article id 213360
but
it
erros out at the cents = gettens line. any help would be great!