Rename help please for. Private Sub Worksheet_BeforeDoubleClick

Hi
I have just copied a code from the internet, pasted to the worksheet but I already have a code with the same name

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Which is the best way to over come the ambiguous name detected error? Can I just rename one of them?
Many thanks

No, there can only be 1 event procedure and if you rename one then it won't execute automatically. You will have to combine the codes using the Parameter Target to determine which block of code should execute.

Many thanks, I thought that might be the case. If I post the codes could you show me what I should do please?

Unless you post the code nobody can help.

Someone will pick it up, probably not me as I'm using a phone but if it's still unanswered in a couple of hours...

This is the code I already have.

Please Login or Register  to view this content.

This also has a Form, Class Module and a Module attached to it.

The new code.

Please Login or Register  to view this content.

The new code is only required on Sheet Inv_1 Range D22:K41.

The DatePicker works in any cell on the worksheet so as long as it can work on cells V6 and V9 that would be good

It I have the the code for DatePicker on a number of sheet but for this sheet just V6 and V9 is all it needs to work on Yes

Ok, thanks for this, I am still working on other bits and so I can't test it at the moment, will let you know when I get it sorted. Thanks

All is good, thanks Norie.