Channel: MrExcel.com

Category: Howto & Style

Tags: excel custom data typesmrexcelcreate data type in excelcreating a custom data type from your own datamicrosoft excelbill jelenexcelcustom data type using javascript apiexcel data typescustom data types in excelsuat ozgurscriptlab in excelcustom data typesoffice 365chris gross

Description: How to create your own custom data types in Excel using ScriptLab and the Javascript API. Important Links: Try out the workbook with my custom data types: 1drv.ms/x/s!As7G72Sl487JliYRnUs0P4hYYNQj?e=rIL25J Github for the example using a Custom Function: gist.github.com/smozgur/a34ad495fb75e19c3e21904875ef0170 Github for the example using an add-in: gist.github.com/smozgur/bf5276622820b1fbbec6690c1689762c Table of Contents (0:00) The quest for a perfect custom data type (1:50) Download a workbook with working custom data types (3:54) The back-end API (5:17) ScriptLab add-in (8:33) ScriptLab Function (10:49) Visual Studio version (12:00) Nerdvana check