andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
Hello all,
I have three named ranges on my sheet. (DAYS, MONTHS, & YEARS) They provide values for my combo box userform. What I am trying to do is to have the ranges resorted to match tomorrows date automatically, and I'm not sure how best to accomplish this.
For the MONTH range, since it's April, that would be listed first, then MAY, etc with March at the bottom.
For the DAY as it is the 18th, the 19th would be at the top, then the 20th etc, wrapping around to the 18th being the 31st item.
The Years would be the same way.
Any ideas on how do pull this off?
I have three named ranges on my sheet. (DAYS, MONTHS, & YEARS) They provide values for my combo box userform. What I am trying to do is to have the ranges resorted to match tomorrows date automatically, and I'm not sure how best to accomplish this.
For the MONTH range, since it's April, that would be listed first, then MAY, etc with March at the bottom.
For the DAY as it is the 18th, the 19th would be at the top, then the 20th etc, wrapping around to the 18th being the 31st item.
The Years would be the same way.
Any ideas on how do pull this off?