Excel Custom Functions: Straight to the Point
Jul 2019 · Tickling Keys, Inc.
Ebook
42
Pages
family_home
Eligible
info
reportRatings and reviews aren’t verified Learn More
About this ebook
Excel users are used to build custom functions—called user-defined functions (UDFs)—in Windows and Mac versions of the application. UDFs can be simply written in Visual Basic Editor (VBE) using the Visual Basic for Applications (VBA) language.UDFs are not portable to Excel Online and Excel for iOS due to the missing VBA capability on these platforms. Therefore, Microsoft has improved the JavaScript API that was already being used for Office add-in development to allow developers to create custom functions attached to the add-ins. These custom functions can be used like any other native functions or UDFs in Excel. While Microsoft calls these functions JavaScript custom functions, they can also be called JavaScript UDFs, which is the name used in this book.This book shows the process of creating JavaScript UDFs in Excel in Developer Preview for Office Insider program subscribers.
About the author
Suat M. Ozgur has more than 20 years of experience developing applications with various programming and scripting languages mainly including Microsoft Visual Basic, Visual Basic for Applications (VBA), Objective C (for mobile development), PHP, and JavaScript. He is a Certified Database Developer working with MySQL, Oracle, and SQL Server databases.
Rate this ebook
Tell us what you think.
Reading information
Smartphones and tablets
Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
Laptops and computers
You can listen to audiobooks purchased on Google Play using your computer's web browser.
eReaders and other devices
To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.
