Get VB6 Text to Speech code using Win32 Speech API (SAPI or TTS) & develope VB6 application with voice options enabled.
Excel VBA Text To Speech – Voice Application Activation
Install Excel VBA Text to Speech & make Excel VBA Speak, Voice messages. Activate Text to Speech(TTS – SAPI Win32 Speech API or Microsoft Speech SDK)