How to Convert Text into Speech Using Macros in Excel 365?
Tags: converttextintospeec, vbamacros
Published: 2020-10-03 10:55:03

---
title: How to Convert Text into Speech Using Macros in Excel 365?
published: true
date: 2020-10-02 12:24:22 UTC
tags: ConvertTextintoSpeec,VBAMacros
canonical_url: https://geekexcel.com/how-to-convert-text-into-speech-using-macros-in-excel-365/
---

## Convert Text into Speech Using Macros:

In this tutorial, we will guide you to learn the steps to **Convert Text into Speech Using Macros in Excel Office 365** with an example. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **Steps to**  **Convert Text into Speech Using Macros:**

Here we come up with some simple steps to convert text into speech using Macros, Kindly, do as follows.

- In the below-given screenshot, you can see the input text strings from **cell B3 to B7.** We are going to convert it into audio with the help of Macros.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-4.png)<figcaption id="caption-attachment-14998">Example</figcaption>

- On the **Developer Tab, select** the **Visual Basic** option under the **Code** section.

![Select Visual Basic option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-Visual-Basic-option-5.png)<figcaption id="caption-attachment-14839">Select Visual Basic option</figcaption>

- You need to activate the sheet where you have the input text string.
- Kindly, **enter the below code**.

VBA code for Converting text into an speech using Macros in Excel

‘Make sure that the input text strings are selected

Sub ConvertTextIntoSpeech()

‘Hear your sentences!

Selection.Speak

End Sub

- You need to **save the code** by selecting it. Then close the window.

![Enter the Source Code](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Enter-the-Source-Code-1.png)<figcaption id="caption-attachment-14999">Enter the Source Code</figcaption>

- You need to open the sheet containing the data. On the **Developer Tab, choose** the **Macros option** in the **Code** section.

![Choose the Macros option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-the-Macros-option-3.png)<figcaption id="caption-attachment-14841">Choose the Macros option</figcaption>

- You need to make sure that your macro is selected and **click** the **Run** button.

![Macro dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Macro-dialog-box-1.png)<figcaption id="caption-attachment-15000">Macro dialog box</figcaption>

- Now, the **text strings are converted into audio**.

## **A Brief Summary:**

In this tutorial, we guided you to learn the steps to **Convert Text into Speech Using Macros in Excel Office 365** with an example. Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Add Date in Header Using Macros (VBA) in Excel Office 365?](https://geekexcel.com/how-to-add-date-in-header-using-macros-vba-in-excel-office-365/)
- [Unmerge All Cells Using Macros (VBA) in Excel Office 365!!](https://geekexcel.com/unmerge-all-cells-using-macros-vba-in-excel-office-365/)