• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA CODE BASED ON CALENDER DATE SELECTION

Hi Team,
could you please find the attachment and give the solution.


Thanks
 

Attachments

  • VBA CODE BASED ON CALENDER DATE SELECTION.xlsx
    378.6 KB · Views: 2
Hi,

I'm not sure I understood the requirement, but if you wanted a "Date Picker" to input the dates and formulas to count the matches in "master" sheet, then please refer to the attached file.

Simply select on of the highlighted cells and you will be prompted to select a date.

Let me know if I understood correctly and if it is working as intended.

Adapted from: http://trevoreyre.com/portfolio/excel-datepicker/
All credit to him!
 

Attachments

  • VBA CODE BASED ON CALENDER DATE SELECTION.xlsm
    463.3 KB · Views: 12
Last edited:
Back
Top