Ok i have done alot of research today, and i tried 3 or 4 different codes and none of them have worked. sometimes i get a compilation error and others just execute the macro as if the code wasn't even there.

here is the setup:

i have a control button on a sheet that when clicked shows a userform, that asks for tag id and qty. this updates another sheet and when its done shows another user form with a success message. when this message pops up i would like it to play a wav file (its from borat when he says GREAT SUCCESS!)

any ideas on how to get a wav file to play from a user form control?