The most comprehensive macro for converting amount (numbers) to words in Indian currency. Flexible and configurable output. Sixteen parameters!
Change what you call Rupees and Paisa, change case, decide whether to put Only, add commas, define spelling of lakhs and more.
Easy to use and versatile customization dialog to generate the function syntax without typing.
The code is a masterclass in writing VBA macros. By my friend and a tech genius Raj Chaudhuri (github.com/rajch)
Download add-in file (zip)
efficiency365....
Contents 📚
00:00 - Intro
00:28 - Download and Install
01:46 - AmountToWords function
02:56 - Function generator
03:29 - Keyboard Shortcuts
05:45 - Source Code
Blog article
efficiency365....
Github link for javascript version
github.com/raj...
Related videos 📺
Apply Excel chart templates - Macro - • Apply Excel chart temp...
GetPivotData macro - Copy from pivot and paste as GetPivotData - • GetPivotData macro - C...
Arrange Pictures in one click - PowerPoint Macro - arrange 100s of pictures instantly - • Arrange Pictures in on...
Animate PowerPoint Tables - Split individual cells and animate in just two clicks - Macro. - • Video
For transforming efficiency across your organization
Contact Dr Nitin at asknitin@maxoffice.co
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency36...
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency36...
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365....
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envat...
Created using Adobe Premiere: www.adobe.com/...
AI based captions: videoindexer.ai (Microsoft service)
Негізгі бет Amount to Words Excel Macro for India - 16 parameter Function |
Пікірлер: 2