Forum Discussion
Excel VBA Code Macro Not Showing in Developer Macros
I have Dollar amounts as $1000.00 in one column. Need the numbers converted into text for legal dovuments e.g. $1000.00 into text format One Thousand Dollars. I am using https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98 code and has saved it in my excel file as Module1 . Howver it is not showing in the Macros on top. Any suggestions?
4 Replies
This UDF function which will appear in the function list, You need to type in a cell =SPELLNUMBER
this link might be helpful for you https://youtu.be/eMA39dU3UOE
or
Your macro setting might be disable which is not allowing to run the code.
Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
Getting error with code:
If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))
1. Your video goes too fast to follow steps. Wish it was slower to follow steps.
2. How to correct the following red color error (Bold Below)
DecimalPlace = InStr(MyNumber, ".")
' Convert cents and set MyNumber to dollar amount.
If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
3. Macro setting is not diasbled.
- Got Macro working. Getting following error
Result = Result & GetDigit _
Right(TensText, 1)) ' Retrieve ones place.
