Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting MsgBox Text | Excel Programming | |||
Formatting text differently within a Msgbox | Excel Programming | |||
MsgBox formatting | Excel Programming | |||
help with Msgbox | Excel Programming | |||
Formatting a MsgBox number | Excel Programming |