/Notify

A simple module that uses windows notify api to send messages to the user.

Primary LanguageVBA

How to Install

Open your workbook in Excel. Press Alt + F11 to open Visual Basic Editor (VBE). Right-click on your workbook name in the "Project-VBAProject" pane (at the top left corner of the editor window) and select Insert -> Module from the context menu. Copy the VBA notify code and paste it to the right pane of the VBA editor ("Module1" window). Or just download and add the notify.bas file to your workbook.

Syntax

toast (titleMessage, [infoMessage], [flagOfMessage])

Flags for the balloon message..

None = 0

Information = 1

Exclamation = 2

Critical = 3

Example

toast "Hello World", "from Excel",1

It is possible to use emojis such as 😍 image

Just convert it to chrW code

toast ChrW(-10179) & Chrw(-8691), "from Excel"