Results 1 to 4 of 4

Method speak of object speech failed

Threaded View

ricklou Method speak of object speech... 04-05-2019, 03:22 PM
Richard Buttrey Re: Method speak of object... 04-05-2019, 03:38 PM
ricklou Re: Method speak of object... 04-05-2019, 03:55 PM
Richard Buttrey Re: Method speak of object... 04-06-2019, 05:34 AM
  1. #1
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Method speak of object speech failed

    Need some help -trying to run a simple speech macro and Im getting the following error.
    Sub Speak()
    Application.ScreenUpdating = False
    Sheets("Test").Activate
    Dim Lastrow As Long
    Dim R1 As Range, R2 As Range, R3 As Range
    
    With Sheet4      ' Change Sheet No. to suit
        For i = 8 To 8
            If .Range("J" & i).Value = .Range("K" & i).Value Or _
               .Range("J" & i).Value = .Range("L" & i).Value Or _
               .Range("K" & i).Value = .Range("L" & i).Value Then
        Application.Speech.Speak "You are not allowed to do that"
     
    End If
        Next i
    End With
    Sheets("Test").Activate
    Application.ScreenUpdating = True
    
    
    End Sub
    Rep for any help to solve above
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Method range of object failed - Please help
    By Whitethorn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2018, 09:45 AM
  2. [SOLVED] speech speak with message box and a reminder every 2 minutes
    By John Vieren in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2018, 03:43 PM
  3. Speak - Speech - Speak numbers individually
    By BDD2015 in forum Excel General
    Replies: 8
    Last Post: 03-23-2017, 08:32 PM
  4. Replies: 1
    Last Post: 03-16-2016, 11:09 AM
  5. [SOLVED] How to make XL.Speech.Speak talk in a male voice
    By DPWM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 04:43 PM
  6. [SOLVED] Method range of object failed
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-02-2013, 06:55 AM
  7. Speech Object and Speak Method
    By DanBlum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2011, 10:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1