+ Reply to Thread
Results 1 to 4 of 4

Ambiguous name detected: Worksheet_BeforeDoubleClick

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Ambiguous name detected: Worksheet_BeforeDoubleClick

    hi all

    Im having trouble with the follow error 'Ambiguous name detected: Worksheet_BeforeDoubleClick' I am trying to build a macro so that when i click on cell D6 macro1 runs & then when I click on D7 another macro runs.

    Below is the code that I wrote, does anyone know how to incorporate both codes so that I dont have the above error coming up? Please remember I do not want both macros to be run at the same time - I only want one macro to run when a particular cell is double clicked

    Please Login or Register  to view this content.
    Thanks in advance
    Last edited by ConfusedaboutVBA; 03-24-2013 at 08:39 PM.

  2. #2
    Forum Contributor
    Join Date
    01-13-2013
    Location
    Oklahoma
    MS-Off Ver
    Office 2007 / Office 2010
    Posts
    123

    Re: Ambiguous name detected: Worksheet_BeforeDoubleClick

    You forgot to close the code block.

    You can only have one of the BeforeDoubleClick subs, you need to check inside of it for each of the cells you want.
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Ambiguous name detected: Worksheet_BeforeDoubleClick

    Hi,

    You can't have two procedures with the same name. Neither can you manually write procedures like sheet event procedures.

    You need to use code like

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Ambiguous name detected: Worksheet_BeforeDoubleClick

    Oh fantastic! Thank you very much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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