Forum Discussion

Vishwanath_Tiwari's avatar
Vishwanath_Tiwari
Copper Contributor
Nov 24, 2021

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...
Macros and VBA
ExcelExciting's avatar
ExcelExciting
MVP
Nov 25, 2021

Hi Vishwanath_Tiwari,

 

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.

Vishwanath_Tiwari's avatar
Vishwanath_Tiwari
Copper Contributor
Nov 25, 2021

ExcelExciting 

 

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. 

  • Vishwanath_Tiwari's avatar
    Vishwanath_Tiwari
    Copper Contributor
    Nov 27, 2021
    Got Macro working. Getting following error

    Result = Result & GetDigit _

    Right(TensText, 1)) ' Retrieve ones place.

Resources