Excel Custom Functions
Excel Custom Functions

Excel Custom Functions

Straight to the Point

Straight to the Point

COMPUTERS

42 Pages, 8 x 10

Formats: ebook: EPUB

ebook: EPUB, $4.99 (US $4.99) (CA $6.99)

Publication Date: July 2018

ISBN 9781615472598

eBook

eBook Editions Available

Will it work on my eReader?
Price: $4.99
NOTE: You are attempting to order an e-book. Please see will it work on my eReader? for directions on how to enjoy this book on your eReader device.
 
add ebook to cart
 

Overview

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.

Author Biography

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.

Need Help with
Your Order?

Contact IPG:

1-800-888-4741

orders@ipgbook.com

Need Help with
Your Order?

Contact IPG:

1-800-888-4741

orders@ipgbook.com