TheSmallman.com

an XL ideas Lab

  • Home
    • Excel Dashboard Course
    • Financial Modelling Course
    • Excel Infographics Course
    • Excel VBA Course
  • Models
  • Native Excel
  • Charts
  • Dashboards
  • Infographics
  • Modelling
  • VBA
  • Blog
  • About
Menu

Excel Dashboards VBA and more

Street Address
City, State, Zip
Phone Number
an XL ideas Lab

Your Custom Text Here

Excel Dashboards VBA and more

  • Home
  • Courses
    • Excel Dashboard Course
    • Financial Modelling Course
    • Excel Infographics Course
    • Excel VBA Course
  • Models
  • Native Excel
  • Charts
  • Dashboards
  • Infographics
  • Modelling
  • VBA
  • Blog
  • About

Make Excel Speak

January 1, 2018 Marcus Small
Talk.JPG

Ever wondered  how to make Excel speak text out loud?  Well I was reading some cool posts on Ozgrid before Christmas and came across this bit of fun.  It is a tool which allows you to have a bit of a laugh with your work mates.  Enter your phrase in the cell provided and click the button next to it. Whatever you type in the cells will be spoken in a computerised voice.  The following is the gold to make it happen.

Option Explicit

Sub TalktoMe()
Dim txt As String

txt = [D11]
Application.Speech.Speak txt
End Sub

The cell D11 contains the text you wish spoken out loud.  The code should run when you press the button on the sheet. 

If you wish the code to run a bit more autonomously then add the code to a worksheet event.  The event could be if a particular group of cells is clicked on.  To make things easier I will name the cells D11 - 'Talk'.  The following would be put in the worksheet module where the code is to be run from.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("Talk")) Is Nothing Then TalktoMe
End Sub

Or it could be when the worksheet  is clicked on.

Private Sub Worksheet_Activate()
   TalktoMe
End Sub

The following is an example file with two sheets which work on the premise above.

ExelTalk.xlsx

← Delete Blank and Zero Value Cells from ColumnsExcel - Too Many Different Cell Formats →

Featured Posts

Evaluate and Filter Part 2

Evaluate and Filter Part 2
April 26, 2015

 Showing Trends with a Chart

Showing Trends with a Chart
March 5, 2015

Excel VBA to Sort an Array

Excel VBA to Sort an Array
February 23, 2015

 Excel VBA Slicer Selection

Excel VBA Slicer Selection
January 15, 2015

Recent Posts

Protect a Worksheet, Use the Autofilter

Protect a Worksheet, Use the Autofilter October 18, 2018

Countifs Across Sheets

Countifs Across Sheets October 10, 2018

Excel VBA to Select Sheets

Excel VBA to Select Sheets September 22, 2018

Power BI Desktop Dashboard

Power BI Desktop Dashboard August 20, 2018

New Excel Dashboard Tools

New Excel Dashboard Tools August 1, 2018

Watch This Space

Watch This Space July 11, 2018

The Fuzzy World of Financial Modelling

The Fuzzy World of Financial Modelling May 31, 2018

Excel Autofill - Fill Down to Bottom of Range

Excel Autofill - Fill Down to Bottom of Range April 8, 2018

Social Media Dashboard in Excel

Social Media Dashboard in Excel April 5, 2018

Range Areas in Excel with VBA

Range Areas in Excel with VBA March 15, 2018

 

TrainiNg

  • Dashboarding with Excel
  • Visual Analytics
  • Advanced Dashboard Design in Excel
  • Financial Modelling in Excel
  • Advanced Financial Modelling in Excel

 

  • 3 Statement Modelling in Excel
  • Project Financial Modelling
  • PowerPivot
  • Excel Automation with VBA
  • Financial Modelling with VBA

Follow US:

 

marcussmall@thesmallman.com
 

TheSmallman.com - Making your small systems hum...
© Copyright theSmallman.com All Rights Reserved.