theWizard
09-18-2014, 09:10 AM
I am a VB.NET person for the most part and struggle sometimes with VBA when it comes to commands/functions that seem easy and natural in VB.NET I have a VB.NET program I wrote that uses speech recognition to enter data into fields in a dataview and then if certain values are spoke other triggers may occur. For instance I have a text box that when I speak it take what I speak and adds the count to a dataview. I do this by speaking example: '44 add'. This adds 44 to my text box and adds the value to the dataview. Then I run code after that says if you are >40 and < 60 then make the back ground color green, if it's >100 then back ground color is changed to red. But with Excel having so many other built-in features that otherwise I would need to program in my VB.Net app. I want to use Excel/VBA for this but I can figure out how to program the sub in VBA to intercept what is spoken and then run code if certain conditions are met. One thing I don't like is the insert box that automatically pop's up when using standard voice recognition in Excel. Can anyone give my an insight on this matter?