Select All Selections in ListBox1 that contain X

[EnigmaMatter]

Hello,

I have a ListBox1 full of dates formatted as M/D/YYYY or M/DD/YYYY.

When I click CommandButton1, I want all dates that contain 2014 to be selected.

I have attached a sample workbook. Any ideas?

[Norie]

Try this.

Please Login or Register  to view this content.

[EnigmaMatter]

...I would have never guessed there was a built-in method for that.

Is there something similar for defining months?

I am trying to make a button for Quarter 1, Quarter 2, etc.

[Norie]

No, but it wouldn't be too hard to do it for quarters as long as you had a clear definition of the quarters.

For example Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31 for quarters 1,2,3,4 respectively.

[allenz0rz]

For months:

same coding, but with "Month" instead of "Year", and value from 1 to 12.

Example with month of December:

Please Login or Register  to view this content.

[EnigmaMatter]

Thanks to both of you.

[EnigmaMatter]

I have a FU question, that should probably be in a new thread.