ambiguous name detected : Worksheet_beforedoubleclick

hi.. i need help on how to fix the code below..

Please Login or Register  to view this content.

Hello eina28,

Part of your problem was you had duplicate events. They were empty, no code in them, but the Declaration lines were there. I removed those and added the Option Explicit statement. This will inform you whenever you have not declared a variable or another variable by that name has been declared. Here is the cleaned code. Delete all the other code and paste this code in its place.

Please Login or Register  to view this content.

I think you better use validation to prevent duplicate entries e.g in cell A5:

Validation/
custom/

PHP Code: 

=countif(A:A,A5)=1 


But if you stick to VBA, the worksheet_change event can be reduced to :

Please Login or Register  to view this content.