Jul 14 2021 05:18 PM
Jul 15 2021 02:20 PMSolution
Jan 03 2022 10:40 AM
@Sudhaji check the string you're sending to the speech module. I had the same problem with the minus sign until I realized that I hadn't isolated the number value from the text that comes before it, as shown in this example:
Application.Speech.Speak ("The number is" & intVariable)
Adding a space allowed the speech module to recognize the sign:
Application.Speech.Speak ("The number is " & intVariable)
A quick test showed that VBA just works with the base value of the cell and can't see the cell formatting. Specifically, writing the cell value to the debug window with debug.print() gives a standard negative number regardless of cell format. The vocal output was also just the base value.