This new API will give developers a chance to create custom data types for inputs and outputs as well as enable certain custom functions. Excel developers will be able to create their own add-ins or ...

You can use dialog boxes for tasks such as displaying sign-in pages that can't be opened directly in a task pane, requesting that the user confirm an action, or hosting videos that might be too small ...

For my custom functions, I use a dialog box using displayDialogAsync method to open the dialog box and display a list of data that which user can select, and that selected value is then sent to Excel ...

To create a custom list, you should first go to the File tab and click on Options. In the Excel Options dialog box, scroll down to the General section and click on the Edit Custom Lists button.

Microsoft is opening up Excel to developers with a new JavaScript API. It will let developers use custom data types like images, cards, and arrays.