Scroll Screen to First Date in List

[delaing]

Would appreciate help with a routine that will move/scroll the screen to the first date in a list of dates triggered by a dropdown selection.

Attached is a sample wkbook where the sheet has Freeze Panes applied so the headings will remain visible. When the user selects a month name in the dropdown, the screen will scroll to the first date found of that month. And, the first date may not be the first day of that month (i.e. 2/5/16, 5/5/16).
The list of dates will extend down beyond the extent of the sample range shown as dates will be added to the list.

Let me know if this description is not sufficient.

Thank you,
Delain

(There are no macros currently in the xlsm; just saved in that format anticipating a workbook code event.)

[karedog]

Maybe :

Please Login or Register  to view this content.

[delaing]

Your code works great if I use a command button to activate after selecting the Month in the dropdown.

Now, how would I wrap this with a Change Event so that the code runs when the user selects using the dropdown?

Where did I get it wrong?

Please Login or Register  to view this content.

Thank you,
Delain

[karedog]

You are welcome.

You should put the code in Worksheet_Change() event, not Worksheet_SelectionChange() event :

Please Login or Register  to view this content.

[delaing]

Excellent; just what we needed!

Thanks for your quick attention to this.

Delain

[delaing]

Excellent; just what we needed!

Thanks for your quick attention to this.

Delain

[karedog]

You are welcome. Thanks for marking the thread as solved and for the the rep. points.


Regards