This page has 1 thread | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Talking to Excel to fill in your input forms, using speech recognition and VBA Part one of a three-part series of blogs
What happens when you combine the magic of speech recognition with the power of VBA? A user form which you can fill in without a keyboard! Using your voice to fill in a VBA form (this blog) Setting up speech recognition Integrating speech recognition with VBA

Talking to Excel to fill in your input forms, using speech recognition and VBA

Part one of a three-part series of blogs

What happens when you combine the magic of speech recognition with the power of VBA? A user form which you can fill in without a keyboard!

Using your voice to fill in a VBA form (this blog)
Setting up speech recognition
Integrating speech recognition with VBA

Posted by Andy Brown on 13 March 2020

Using your voice to fill in a VBA form

Wouldn't you like to be able to speak your commands to VBA?

Want to list out film details? Just tell Excel which title you want (you can download this workbook here, although it won't work until you set up speech recognition on your computer, and you're probably best reading the rest of this blog and setting up your own simple example).

The rest of this blog explains how to set up speech recognition, then how to access the underlying speech recognition object library in VBA.

Thanks to Marshall Vance for prompting this blog with an emailed question!

Should you want to explore this topic further, here are some deep dive links after the shallow dive presented in this blog:

Link	Notes
Mike Forde	The ultimate guide to using speech recognition within VBA.
Microsoft documentation	Light reading (not!) on the speech recognition library.
.NET documentation	Documentation on the Speech.Recognition .NET namespace.
A C# example	An example of speech recognition using C#.