VBA with date picker applied to specific cells.

Hi all,


I have a worksheet which is using a date picker and which a couple of months ago I was working on (also thanks to contributors from this forum).. https://www.excelforum.com/excel-pro...te-picker.html

I would like to carry on some adjustments and was wondering whether someone can please assist me with the below.

Basically I have a VBA embedded within a form, which provides for a date picker.

In order to enable this form, a 'worksheet VBA' prompts the form to be shown if the user clicks on either column A, or column C, or column E or Column G. For ease of reference, I have a attached a sample with the current set-up (please refer to sheet called 'Current').

I would like to propose some new changes as per sheet called 'proposed' from the attached file.

Basically I am trying to have the form only show if the user selects the cells which are coloured in yellow.

Not sure whether it is possible to somehow amend the code or if there is a workaround?

Would really appreciate a lot your kind help!!

Many thanks and much appreciated!!

Regards

Keibri