How To Show A System Tray Notification Balloon

[waimea]

I read this https://wellsr.com/vba/2017/excel/show-system-tray-notification-balloon-when-macro-is-done/ post where a system tray notification is showed upon macro completion.

However, I can't get it to work.

Does anyone have any experience with system tray notifications? (I am using Office Pro Plus on Windows 10).

[Leith Ross]

Hello walmea,

At what line in the code do you receive an error?

What is the error?

What version of Windows are you running?

[waimea]

Hi Leith Ross,

thank you for your reply! I tried it on a new install of Office 365 Pro Plus 32-bit and now it doesn´t give me an error but there is no notification icon.

I am using Windows 10 Home 64-bit.

[waimea]

I have a user form with the user form code in it and the rest of the code in a module.

It works when I run the user form code but not the call to MacroFinished??

[waimea]

It works when I comment out


'AppActivate (ThisWorkbook.Name) 'flash your existing workbook

in the MacroFinished sub. I am not sure why it works but it does.

Are there any more windows user interface things that can be done with VBA?

[waimea]

Would it be possible to replicate this code and create a "system tray" notification in excel using shapes and perhaps visibility from 0 to 100%?