lanutrition.blogg.se

I have the following code to put data from a VBA userform into Excel SpellNumber = SpellNumber & " And Cents "

SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1))) SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred " If i = 1 And Val(Left(FIGURE, 2)) > 0 ThenĮlseIf i = 2 And Val(Left(FIGURE, 2)) > 0 ThenĮlseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1))) SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2))) Ringgit Malaysia : Nineteen Thousand Nine Hundred NinetyNine Onlyįunction SpellNumber(amt As Variant) As Variant Amount from 20,000 and above only show thousand? Please help! I am using below code, but it only untill 19,999.