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.
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
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
Hi,
I am not really good in VBA codes. How do i combine those two codes in single procedure?
Thanks
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
I am actually confuse. I check the codes and i can't find the name that has the same name on each worksheet.
Thanks
Check the modules.
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.
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
I meant " I also did check the vba code and did not find anything with the same name"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks