display the message box and sound simultaneously - VBA
0
In the code below, the song is played first, after which the message is displayed. How to display the Message Box and Sound Play simultaneously in the code below?
Private Declare PtrSafe Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As LongPtr, ByVal
dwFlags As Long) As Boolean
Private Sub CommandButton1_Click()
Call PlaySound("c:windowsmediatada.wav", 0, SND_ASYNC Or SND_FILENAME)
Msgbox "Process completed successfully."
End Sub
microsoft-excel audio vba
asked Nov 23 '18 at 8:14
First Last
164
add a comment |
0
In the code below, the song is played first, after which the message is displayed. How to display the Message Box and Sound Play simultaneously in the code below?
Private Declare PtrSafe Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As LongPtr, ByVal
dwFlags As Long) As Boolean
Private Sub CommandButton1_Click()
Call PlaySound("c:windowsmediatada.wav", 0, SND_ASYNC Or SND_FILENAME)
Msgbox "Process completed successfully."
End Sub
microsoft-excel audio vba
asked Nov 23 '18 at 8:14
First Last
164
The msgbox appears immediately and won't depend on you pressing OK to run the next line. Why not just swap the call playsound and msgbox lines around?
– spikey_richie
Nov 23 '18 at 8:18
2
@spikey_richieMsgBoxis modally displayed and halts execution until it returns (= the user dismisses it). The sound will only be played once the dialog is closed.
– Inarion
Nov 23 '18 at 8:21
Can you show the assignments forSND_ASYNCandSND_FILENAMEas well? (Although I assume the latter is set correctly, otherwise you'd get the wrong sound played.)
– Inarion
Nov 23 '18 at 8:26
add a comment |
0
0
0
In the code below, the song is played first, after which the message is displayed. How to display the Message Box and Sound Play simultaneously in the code below?
Private Declare PtrSafe Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As LongPtr, ByVal
dwFlags As Long) As Boolean
Private Sub CommandButton1_Click()
Call PlaySound("c:windowsmediatada.wav", 0, SND_ASYNC Or SND_FILENAME)
Msgbox "Process completed successfully."
End Sub
microsoft-excel audio vba
asked Nov 23 '18 at 8:14
First Last
164
In the code below, the song is played first, after which the message is displayed. How to display the Message Box and Sound Play simultaneously in the code below?
Private Declare PtrSafe Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As LongPtr, ByVal
dwFlags As Long) As Boolean
Private Sub CommandButton1_Click()
Call PlaySound("c:windowsmediatada.wav", 0, SND_ASYNC Or SND_FILENAME)
Msgbox "Process completed successfully."
End Sub
microsoft-excel audio vba
microsoft-excel audio vba
asked Nov 23 '18 at 8:14
First Last
164
asked Nov 23 '18 at 8:14
First Last
164
asked Nov 23 '18 at 8:14
First Last
164
asked Nov 23 '18 at 8:14
First Last
164
asked Nov 23 '18 at 8:14
First Last
164
164
The msgbox appears immediately and won't depend on you pressing OK to run the next line. Why not just swap the call playsound and msgbox lines around?
– spikey_richie
Nov 23 '18 at 8:18
2
@spikey_richieMsgBoxis modally displayed and halts execution until it returns (= the user dismisses it). The sound will only be played once the dialog is closed.
– Inarion
Nov 23 '18 at 8:21
Can you show the assignments forSND_ASYNCandSND_FILENAMEas well? (Although I assume the latter is set correctly, otherwise you'd get the wrong sound played.)
– Inarion
Nov 23 '18 at 8:26
add a comment |
The msgbox appears immediately and won't depend on you pressing OK to run the next line. Why not just swap the call playsound and msgbox lines around?
– spikey_richie
Nov 23 '18 at 8:18
2
@spikey_richieMsgBoxis modally displayed and halts execution until it returns (= the user dismisses it). The sound will only be played once the dialog is closed.
– Inarion
Nov 23 '18 at 8:21
Can you show the assignments forSND_ASYNCandSND_FILENAMEas well? (Although I assume the latter is set correctly, otherwise you'd get the wrong sound played.)
– Inarion
Nov 23 '18 at 8:26
The msgbox appears immediately and won't depend on you pressing OK to run the next line. Why not just swap the call playsound and msgbox lines around?
– spikey_richie
Nov 23 '18 at 8:18
The msgbox appears immediately and won't depend on you pressing OK to run the next line. Why not just swap the call playsound and msgbox lines around?
– spikey_richie
Nov 23 '18 at 8:18
2
2
@spikey_richie
MsgBox is modally displayed and halts execution until it returns (= the user dismisses it). The sound will only be played once the dialog is closed.– Inarion
Nov 23 '18 at 8:21
@spikey_richie
MsgBox is modally displayed and halts execution until it returns (= the user dismisses it). The sound will only be played once the dialog is closed.– Inarion
Nov 23 '18 at 8:21
Can you show the assignments for
SND_ASYNC and SND_FILENAME as well? (Although I assume the latter is set correctly, otherwise you'd get the wrong sound played.)– Inarion
Nov 23 '18 at 8:26
Can you show the assignments for
SND_ASYNC and SND_FILENAME as well? (Although I assume the latter is set correctly, otherwise you'd get the wrong sound played.)– Inarion
Nov 23 '18 at 8:26
add a comment |
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377753%2fdisplay-the-message-box-and-sound-simultaneously-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377753%2fdisplay-the-message-box-and-sound-simultaneously-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
The msgbox appears immediately and won't depend on you pressing OK to run the next line. Why not just swap the call playsound and msgbox lines around?
– spikey_richie
Nov 23 '18 at 8:18
2
@spikey_richie
MsgBoxis modally displayed and halts execution until it returns (= the user dismisses it). The sound will only be played once the dialog is closed.– Inarion
Nov 23 '18 at 8:21
Can you show the assignments for
SND_ASYNCandSND_FILENAMEas well? (Although I assume the latter is set correctly, otherwise you'd get the wrong sound played.)– Inarion
Nov 23 '18 at 8:26