MrKowz
Well-known Member
- Joined
- Jun 30, 2008
- Messages
- 6,653
- Office Version
- 365
- 2016
- Platform
- Windows
Is there a way to populate a dropbox in a user form that has years in it starting from 2008 until the current year?
It seems like a dumb thing to do right now, but this is a macro that will be used for many years to come for this company, and I want to make the userform idiot-proof.
For example: This year, I only want the dropbox to show 2008... next year I want it to show 2008 and 2009. In the year 2014, I want it to show 2008, 2009, 2010, 2011, 2012, 2013, 2014. And so on.
If this is possible, and someone has coding for it, if I could also get instructions on where to place it in a macro, that would be great. Currently I use the following macro to call my userform:
Thank you!
It seems like a dumb thing to do right now, but this is a macro that will be used for many years to come for this company, and I want to make the userform idiot-proof.
For example: This year, I only want the dropbox to show 2008... next year I want it to show 2008 and 2009. In the year 2014, I want it to show 2008, 2009, 2010, 2011, 2012, 2013, 2014. And so on.
If this is possible, and someone has coding for it, if I could also get instructions on where to place it in a macro, that would be great. Currently I use the following macro to call my userform:
Code:
Sub eTPAProcessingPerformance()
ETPAREPORT.Show
End Sub
Thank you!