I have this in a module, and it will does not show Eight Cents on number 4
From Help
The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used.
I put this in word and did a word count and got 347 characters any ideas on why it will not let more characters show?
Thanks
Ans = Application.InputBox("Type in number will format 125.38 like.." & vbCr & _
"(1) = One Hundred Twenty Five Point Three Eight" & vbCr & _
"(2) = One Hundred and Twenty Five Point Three Eight" & vbCr & _
"(3) = One Hundred Twenty Five and 38/100," & vbCr & _
"(4) = One Hundred Twenty Five Dollars and Thirty Eight Cents", "Format For Spelling", 4)
From Help
The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used.
I put this in word and did a word count and got 347 characters any ideas on why it will not let more characters show?
Thanks
Ans = Application.InputBox("Type in number will format 125.38 like.." & vbCr & _
"(1) = One Hundred Twenty Five Point Three Eight" & vbCr & _
"(2) = One Hundred and Twenty Five Point Three Eight" & vbCr & _
"(3) = One Hundred Twenty Five and 38/100," & vbCr & _
"(4) = One Hundred Twenty Five Dollars and Thirty Eight Cents", "Format For Spelling", 4)