PDA

View Full Version : [SOLVED] How To Show A System Tray Notification Balloon



waimea
12-26-2018, 08:20 AM
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
12-26-2018, 09:37 AM
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
12-26-2018, 09:54 AM
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
12-26-2018, 09:58 AM
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
12-26-2018, 10:32 AM
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
12-27-2018, 01:08 AM
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%?