Very Simple Spell (Number to Words) 001 to 999 in VBA

Hi !

• Why dash variable is not a String in the Dim statement ?
  
  
• dash = "" is useless, you can remove it …
  
  
• For string concatenation better is to use & operator instead of + …

Originally Posted by Marc L

Hi !

• Why dash variable is not a String in the Dim statement ?
  
  
• dash = "" is useless, you can remove it …
  
  
• For string concatenation better is to use & operator instead of + …

Thanks Marc L. It is an old habit to to use the "" .

I found the + to befaster than & when the string is already defined in a variable. Yes you are right. Thanks again.

Attached a User Defined Function adapted from Microsoft site.
The function is called by 'NW'
Two examples of cell formula use are illustrated in column 'A'

By direct conversion in cell

=NW(yournumber)

By reference to another cell (C5) value formula in cell A5

=NW(C5)

Also can be called within VBA as a Worksheet function.

torachan.

Originally Posted by torachan

Attached a User Defined Function adapted from Microsoft site.
The function is called by 'NW'
Two examples of cell formula use are illustrated in column 'A'

By direct conversion in cell

By reference to another cell (C5) value formula in cell A5

Also can be called within VBA as a Worksheet function.

torachan.

Thanks torachan. The Microsoft site function is too long for a simple task. It is simple for reading and learning.

Originally Posted by torachan

Attached a User Defined Function adapted from Microsoft site.
The function is called by 'NW'
Two examples of cell formula use are illustrated in column 'A'

By direct conversion in cell

By reference to another cell (C5) value formula in cell A5

Also can be called within VBA as a Worksheet function.

torachan.

I have downloaded the file and examined the code for converting numbers from 001 to 999 to words.
There are 3 functions with losts of code and "Select Case" statement to do what a 5 statements do in the code I posted.

@MohsenAlyafei, you are correct, your contribution is simple, reading & learning, however has very restrictive practical use.
I only included my submission as it extended the possibilities to those that read this thread, illustrating what can be achieved with imagination.
torachan.

Originally Posted by torachan

@MohsenAlyafei, you are correct, your contribution is simple, reading & learning, however has very restrictive practical use.
I only included my submission as it extended the possibilities to those that read this thread, illustrating what can be achieved with imagination.
torachan.

Thanks torachan.