VBA code that you can use to use text-to-speech in Excel.
VBA Code:
Sub TextToSpeech()
Dim speech As Object
Dim textToSpeak As String
' Create a new speech object
Set speech = CreateObject("SAPI.SpVoice")
' Get the text to speak
textToSpeak = Range("A1").Value ' Change the cell reference as desired
' Speak the text
speech.Speak textToSpeak
End Sub
Nazim Khan — Founder & Editor, TechGuruPlus.com
[MBA in Finance]
Nazim Khan has spent over ten years working with Excel, Tally and office documentation in accounts, finance and MIS roles. He has been running TechGuruPlus.com since 2016, where he publishes free editable templates for office work, and the YouTube channel Business Excel. He has trained more than 50,000 people online. Every template on this site is built and checked by him before it is published.
