+ Reply to Thread
Results 1 to 2 of 2

"runtime error 287" on speak cells when esc. key is pressed

  1. #1
    Registered User
    Join Date
    01-14-2024
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    1

    "runtime error 287" on speak cells when esc. key is pressed

    when the user presses the escape key in the keyboard (while the speak cell in a range of cell is on going) there is an error message appears "runtime error 287" Application defined or object defined - error. how can i solve this?

    by the way this is the code i write on Module 1

    Please Login or Register  to view this content.
    and this is the code on the sheet where i need to execute the code:
    Please Login or Register  to view this content.
    (i got this code from a youtube tutorial but i need to write a code for error handling so that the dialog box with the message runtime error will not appear and the debug mode will not be opened)

    much appreciated your help. thank you
    Last edited by 6StringJazzer; 01-14-2024 at 09:23 AM. Reason: please use code tags

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,032

    Re: "runtime error 287" on speak cells when esc. key is pressed

    Maybe something like this

    Worksheet
    Please Login or Register  to view this content.
    Module
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 10-29-2021, 11:31 PM
  2. Replies: 1
    Last Post: 08-25-2021, 03:40 AM
  3. [SOLVED] RunTime Error 9 when using "With(strName)" to find sheet "strName"
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2016, 09:38 PM
  4. Mac excel error Runtime Error 429 due to CreateObject("Scripting.Dictionary")
    By iamstevetay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2015, 04:21 PM
  5. [SOLVED] Help Resolving Runtime Error "28": Out of stack space while conditionally locking cells
    By Seeki in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2015, 11:22 PM
  6. [SOLVED] Frequently Used Macro now Giving a" Runtime Error '1004 Application-Object Defined Error"
    By rjw524 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2015, 02:39 PM
  7. Merged cells cause "Runtime error 13 type mismatch" problem
    By Ralph Malph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2006, 08:55 AM

Tags for this Thread

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