In this advanced tutorial, we'll be able to easily convert currency to words using VBA. This will be an easy-to-follow instruction, and you don't need to be an expert on VBA for this. If you have a currency other than the dollar, you can do that also.

There are countless situations where you might need to convert currency to words. For example, you are an HR manager creating a pay slip, or you are an accountant and creating a custom report. It is time to convert $100.1 to one hundred dollars and ten cents. In Excel, however, there are no such built-in methods for this type of conversion. But here in this advanced excel tutorial we’ll be able to easily convert currency to words using VBA.

I’ll be creating a custom function and we’ll be using that function just like we use any functions in excel. You'll be able to convert different currencies using this function. This will be an easy-to-follow instruction, and you don’t need to be an expert on VBA for this. Everyone can do this. If you are passionate about learning Excel VBA, you can do that by following our VBA Programming Course.

Now let’s follow the instructions below:

Click on the "developer tab."

Click on "visual basics."

Click on "insert"

Click on "module"

Write the code. Click on the button below to get the code.

Close the VBE

Now write the function =NumbersToWords() in any cell you want.

Done!

Now you may need to convert the formula result to an actual value, and you can do that also. Please check out the video tutorial on how to convert formula results into values in Excel. I’ve explained six ways to do that.

There are a few things you need to consider. If you have a currency other than the dollar, you can use the "Find and Replace" feature and replace "Dollar" with "Rupee" and "Cents" with "Paisa", for example.

You’ll also need to save the workbook as an excel macro-enabled workbook which is .xlsm format. Although you’ve saved the workbook in .xlsm format, you’ll need to click on the "enable content" button every time you open the workbook to enable the macro. This is built-in macro security, and there are ways to avoid it. But for that, you need to understand macro security. If you have any questions, please leave a comment. If you can, please support us by becoming a Patron. Thanks a million for visiting us.