Differences Between Parameters and Arguments

Written by kazamraza no comments

These are used interchangeably, however,A parameter is a variable in a method definition. When a method is called, the arguments are the data you pass into the method's parameters. When a variable is passed to a subroutine or function it is called an argument. The value used in place of the parameter when we make the procedure call is called an argument.

Read more Differences Between Parameters and Arguments

Convert Numbers into Words Using VbA

Written by kazamraza no comments

There is a function BAHTTEXT in Excel that convert number/amount into words, but this function is in Thai language. Excel doesn’t have a default function that displays numbers as English words in a worksheet, but you can add this capability by pasting the following SpellNumber function code into a VBA (Visual Basic for Applications) module. This function lets you convert dollar and cent amounts to words with a formula, so 22.50 would read as Twenty-Two Dollars and Fifty Cents. This can be very useful if you're using Excel as a template to print checks. Open excel and create new excel workbook and save it as Macro Enabled Workbook. To confirm Macro Enabled Workbook Its file extension will be .xlsm.

Read more Convert Numbers into Words Using VbA