BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 13 March 2020
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
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:
This is a great step forward, it helps staff with some disabilities to fill in invoice forms.
Still need to develop the VBA a bit further, but well done Wise Owl and Andy in particular.