changing beep sound

[hmcheung]

how can I change the beep sound? that is, suppose I have a code like this:

sub command1_click()
   beep
end sub

and I want to change the sound of beeping to another wav file, what should I do? thanks!!