vba code for calculation number with comma

If you have multiple numbers in a single cell and need to add them—or perform a calculation—you can use this VBA code. Simply copy and paste the code into a module within your Excel sheet, then use the formula =SumComma(A1) and press Enter to get the result.