Re: Text to Speech



Sub ABC()
Range("B9").Select
Application.Speech.Speak ActiveCell.Text
End Sub


Assumes you have the speech capabilities configured.

--
Regards,
Tom Ogilvy


"James A" <JamesA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B93C461D-48AA-4618-BC3E-F6B176428813@xxxxxxxxxxxxxxxx
How to create a macro to select a call and execute the text to play
function.
--
James A


.



Relevant Pages

  • Re: For Next Loop Question
    ... Curious minds want to know. ... Tom Ogilvy wrote: ... Sub ABC() ...
    (microsoft.public.excel.programming)
  • Re: Help with vb Find
    ... Tom Ogilvy ... "james" wrote in message ... What I have is several hundred cells that start off with ... > does not like the FIND portion (Sub or Function not defined error) ...
    (microsoft.public.excel.programming)
  • Re: format all column width
    ... Not much point in writing Sub in Sub, you can just write the lines of code to ... ABC 'Calls sub routine ABC and will return to next line after execution. ... "Daniel" wrote: ... "Tom Ogilvy" wrote: ...
    (microsoft.public.excel.programming)
  • Re: Hide the spreadsheet
    ... Sub ABC() ... Sub MyExistingSub() ... Tom Ogilvy ... while a macro was running. ...
    (microsoft.public.excel.programming)
  • Re: Prompt for VBAproject password
    ... Tom Ogilvy "Eric van Uden" wrote in message ... > | Sub TryToUnlock() ... > | Dim WB As Workbook ... > | Sub UnprotectVBProject(WB As Workbook) ', ...
    (microsoft.public.excel.programming)