what's error causes compile error sub function not defined when call macro

[Alaa mg]

Hi
I face problem wasn't show before !!
I try calling macro from sheet change event . it gives error compile error sub function not defined when try call test
how can I fix it,please?

 

[Joe4]

You have two procedures named "N", one in the Sheet module and one in Module1. You should name these differently.

Once I corrected that, the code ran just fine.

 

[Alaa mg]

thanks I delete all theses procedures , I don't need it , even if that still the error shows , is there any item from reference should be selected?

 

[Joe4]

What references do you have selected?

 

[Alaa mg]

here is the picture

 

[Joe4]

No, those all look correct to me.
I am not sure. When I removed the one "N" Procedure, it worked fine for me.
So I cannot even re-create the scenario using your file.

My only other suggestion would be to try recreating this on a brand new Excel file, in case the issue is due to some sort of file corruption.

 

[Alaa mg]

My only other suggestion would be to try recreating this on a brand new Excel file, in case the issue is due to some sort of file corruption.

Ok I will try it .