ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MsgBox formatting (https://www.excelbanter.com/excel-programming/368341-msgbox-formatting.html)

Mariner

MsgBox formatting
 
Hello

How do I make a popup message box play a sound file automatically when it
appears. I would also like the box to flash different colours say from grey
to red until the ok button is clicked.

Thanks

Jake Marx[_3_]

MsgBox formatting
 
Hi Mariner,

Mariner wrote:
How do I make a popup message box play a sound file automatically
when it appears. I would also like the box to flash different colours
say from grey to red until the ok button is clicked.


Some options for the MsgBox function will allow you to play default system
sounds when it is displayed (vbExclamation, etc). However, to play a custom
sound or flash colors, you will have to create a UserForm that looks like a
messagebox.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]



RB Smissaert

MsgBox formatting
 
I have uploaded a custom MsgBox to this site:
http://www.planet-source-code.com/vb...65065&lngWId=1

It doesn't flash, but it has a lot of extra options and if you have access
to VB6 than it is very easy to add that option.
Coming to think of it it might be an idea to add that option myself.

RBS

"Mariner" wrote in message
...
Hello

How do I make a popup message box play a sound file automatically when it
appears. I would also like the box to flash different colours say from
grey
to red until the ok button is clicked.

Thanks




All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com