Sound activated sound player

Is there a program or a set of programs for a windows XP computer that can allow me to play a sound when there is a sound.

When some signal of some intensity and continuity will be coming in through the microphone, it will trigger an output of a sound file through the speaker.

Is it possible to find something in this field.
I have Snooper, Adobe Soundbooth4, NCH WavePad.

Is it possible to program something like this using Visual Basic 6?
I never could find any sound analysis - related commands in VB6.