#How to enable macro in excel 2016 ma code#
#How to enable macro in excel 2016 ma download#

#How to enable macro in excel 2016 ma download#

If you don’t have this library, you’ll need to download it. You want to make sure you check the box next to the one that says sapi.dll in the Location field. To do this from your VBA editor, go to Tools > References and scroll down until you see “Microsoft Speech Object Library.” I have two references with that title. To change the voice or speed, you have to add a reference to the sapi.dll Microsoft Speech Object Library. Things get a little more complicated when you want to change the voice of your narrator or the speed at which the narrator talks. They’ll default to False, just like the method. The two optional arguments control the SpeakAsync and Purge arguments. SayIt accepts 3 arguments, but the last 2 are optional. I would enter the formula =SayIt(A1,TRUE) into any cell and now anytime cell A1 changes, my computer will tell me the new value! It won’t waste my time telling me when other cells change - just when the contents of cell A1 changes. Let’s say I’m playing around with my spreadsheet and I want to know the value in cell A1 each time it changes, but I don’t want to stop what I’m doing to look at that cell each time. Speak ( cell1 ), bAsync, , bPurge SayIt = 'Speaking' End Function One way I like to do this is with a custom function (a UDF) designed to let Excel speak the contents of whatever cell I give it.įunction SayIt ( cell1 As Variant, Optional bAsync As Boolean, Optional bPurge As Boolean ) Application. By making Excel repeat the contents of your cells as you enter them, you can confirm whether or not you’ve entered your data correctly. Normally, you would look at your source of data, type the data, then look at your spreadsheet to make sure you typed the data correctly. You need to enter some of these values into Excel. Let’s say you’re looking at data on a PDF, sticky note or website. Play around and set the Purge property to false - you’ll see that it completely waits to finish saying your first string before starting your second one.Īrguably one of the most helpful ways you can get Excel to talk to you is by forcing it to say the value of a cell or multiple cells buried deep on another worksheet.Īnother useful application is when you’re performing data entry. It clears everything it had planned to say and says your new expression. When you play the code, the voice will stop saying the first string mid-sentence and will start saying “Hello, friend!” instead. Speak 'Hello, friend!', SpeakAsync : = True, Purge : = True End Sub Wait ( Now + TimeValue ( '00:00:01' )) Application. Speak 'Excel is talking to me', SpeakAsync : = True Application. Let’s go through a few examples to see how the arguments change the behavior of the speech method:įirst, we’ll add a MsgBox at the end of our original example macro: In other words, it “purges” the queued up text in favor of your new text. Purge - If you set this to True, your macro will stop saying anything it was in the process of saying and start saying your new string, instead.The default is False, since most of the time you’re not feeding the script any XML. SpeakXML - Setting this to True will cause your string to be interpreted as XML and any XML tags you have will not be spoken.In other words, by default your macro will pause until the voice finishes speaking.

#How to enable macro in excel 2016 ma code#

This is usually a good idea because it speeds up your code execution. SpeakAsync - By setting this to True, the VBA compiler will continue to march through your code while the voice is speaking.The other 3 arguments are optional and are described below: The first one, we know, is the string you want your computer to say. By default, it waits until the voice finishes talking before it continues with your macro, but you can change that!įortunately, accepts many arguments. The function gets Microsoft Excel to play whatever string you pass it.