+ Reply to Thread
Results 1 to 10 of 10

ambiguous name detected

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    835

    ambiguous name detected

    Hello all,

    When I click the button "click here" then I get the error message "ambiguous name detected". I combined 2 worksheet in one workbook with the userform on each one. There are two main file, CODE and the OFFICE.

    Here is the sample file:

    https://www.dropbox.com/s/2q6vnhhi0j...TING.xlsm?dl=0



    Thank you.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,637

    Re: ambiguous name detected

    You can have two procedures with the same name in the same module. You need to combine the code into a single procedure.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,234

    Re: ambiguous name detected

    Hi RJ1969,

    You can attach files directly here which is the preferred as I when I tried to look at your file I had to create an account with dropbox.

    Without looking at the file, from my experience that message is because you've got two macros named the same in the same workbook. Make sure each macro has an individual name and try again.

    Thanks,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  4. #4
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    835

    Re: ambiguous name detected

    Hi,
    I am not really good in VBA codes. How do i combine those two codes in single procedure?
    Thanks

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: ambiguous name detected

    You may not need to combine them, they may do the same thing. But you must change the name of one of them - I often just append a 2 or an X at the end
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  6. #6
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    835

    Re: ambiguous name detected

    I am actually confuse. I check the codes and i can't find the name that has the same name on each worksheet.

    Thanks

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: ambiguous name detected

    Check the modules.

  8. #8
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: ambiguous name detected

    I changed all of the Public routines in Filterlist1 to Private and got rid of the ambiguous name but encountered a discrepancy on
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    835

    Re: ambiguous name detected

    Hi

    I just checked the module. I still cant find the same name. Its two different name. The 1st module “mdlfunctions” and the 2nd is “mdlfunctions1”. I also check the vba code in it. Did find with the same name.

    Thanks

  10. #10
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    835

    Re: ambiguous name detected

    I meant " I also did check the vba code and did not find anything with the same name"

+ 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. [SOLVED] Ambiguous name detected
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2016, 10:23 AM
  2. Ambiguous name detected
    By lulu319 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2013, 12:54 PM
  3. Ambiguous name detected...but why?
    By kocinela in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2012, 11:36 AM
  4. [SOLVED] Ambiguous Name Detected
    By stokie21 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2012, 11:01 AM
  5. Ambiguous name detected
    By antony moseley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2010, 03:22 PM
  6. Ambiguous Name Detected
    By TonyforVBA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2010, 01:33 PM
  7. Ambiguous name detected - please help
    By umax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2006, 08:26 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