Subs new to this

[kingsley1]

Hi I’m trying to animate a date picker for a worksheet. I’ve worked out column A as seen in the picture but I want my team to be able to do the same thing in column E when the task is completed. Can anyone help please?

 

[NoSparks]

try changing the Intersect line to

    If Not Intersect(Target, Range("A3:A420")) Is Nothing Or _
       Not Intersect(Target, Range("E3:E420")) Is Nothing Then

 

[kingsley1]

try changing the Intersect line to

    If Not Intersect(Target, Range("A3:A420")) Is Nothing Or _
       Not Intersect(Target, Range("E3:E420")) Is Nothing Then

Thank you Sir! I shall when I get home. Really appreciate it.

 

[kingsley1]

try changing the Intersect line to

    If Not Intersect(Target, Range("A3:A420")) Is Nothing Or _
       Not Intersect(Target, Range("E3:E420")) Is Nothing Then

Good Morning I'm sorry I am very new to this and it doesn't seem to be working for me. Thank you for your suggestion it's no doubt me who just doesn't understand it