calling a DatePicker to change (reset itself) from a macro

  • I would like to add a line to the sub below that changes the value of DatePicker1 back to 1/1/2019

    is there something I can add to this to make that happen?

    Any help is greatly appreciated.


  • I am not used to DatePicker (prefer almost another way of selecting a date!), but maybe try

    1. ActiveSheet.Shapes("DatePicker1").Value = 1/1/2019

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.