Christmas Livestream - Fun Excel VBA Demo and More! Begins 04:38

04:38 Stream Begins

In Tiger's Christmas livestream, we look at a fun, seasonal application of Excel VBA, and chat about plans for next year - if you're looking to push forward your career in 2020 with Excel VBA, you're going to love it!

06:10 Excel VBA Advent Calendar - with speech!
21:30 The Future for Tiger
27:06 Members Monday - push forward your Excel VBA in 2020
37:15 Spreadsheets for Humans - your structured Excel learning journey

Link to download file:

---------------------------------------------
🎫Get Your Channel Membership HERE🎫

🎥🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know

🎬Daily video on Instagram
📺Sister Channel: Excel Spreadsheet Skunkworks (Livestream Only!)

[freddyyang]

Haha, my watch time is always the full video time. Which means that there might be lots of people only tuning in for couple minutes. Merry Christmas! Hope to see you in your next video.

[jk]

Thank you for the tutorial! Script/code below is how to adjust the voice and "Links" is a tab in the workbook that I have the macro and Cells(5, 1) contains the word Hi.



I also activated under Tools > References > Microsoft Speech Object Library - System 32\Speech\Common


Dim speech As New SpVoice
Dim Line As String

Line = Sheets("Links").Cells(5, 1)
Application.speech.Speak "Hello" This is the first (default) voice
speech.Speak Line Still the default voice

Application.speech.Speak Range("A5") Still the default

Application.speech.Speak Line Still the default

MsgBox "You have " & speech.GetVoices.Count & " voices installed" Only have 2 installed
Set speech.Voice = speech.GetVoices.Item(1) Put 1 instead of 0 to change from default

speech.Speak Line Changes to second voice
Application.speech.Speak Range("A5") This is still default (first voice)

Speech.Speak Line Changes to HER (second voice)


End Sub


Nice to be a part of the community, thanks again and Merry Xmas*