Utilizing VBA and a sound API requires a little more elaboration than
I can accomplish in a newsgroup post.
(Not to mention the last time I helped someone add sound to a project
I came close to getting strung up by their co-workers who found the
"Jeopardy" theme a bit annoying. I didn't know that was the plan -
honest!! <grin>)
Either use Google to search for "sound API" and VBA or head over to
one of the VBA newsgroups specific to the application you are using.
Someone there may have some links to tutorials and examples on hand.