LinkBack URL
About LinkBacks
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?
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?
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
...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.
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.
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.
Thanks to both of you.
I have a FU question, that should probably be in a new thread.
Last edited by EnigmaMatter; 03-06-2014 at 06:02 PM. Reason: Should be in new Thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks