KyleJackMorrison
Board Regular
- Joined
- Dec 3, 2013
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hello,
I have a complex sheet that has hundreds of employee's on who have completed courses.
As each month i have to give a list of name to my boss about whose course has been expired (Courses last 2 years). I have the userform all set up, however i can't seem to get the code to search and populate the list box with only people who have been expired.
Here's what my sheet looks like:
<tbody>
</tbody>
As you can see, i would like the listbox1 to display Miss Mary and Mr Smith as their courses have expired past 2 years.
Any help is much appreciated!
KJM
I have a complex sheet that has hundreds of employee's on who have completed courses.
As each month i have to give a list of name to my boss about whose course has been expired (Courses last 2 years). I have the userform all set up, however i can't seem to get the code to search and populate the list box with only people who have been expired.
Here's what my sheet looks like:
Title | Name | ID No. | Course 1 |
Mr | Joe | 22334455 | 01/01/2017 |
Miss | Mary | 11223344 | 10/10/2014 |
Mr | Smith | 99887766 | 01/01/2012 |
<tbody>
</tbody>
As you can see, i would like the listbox1 to display Miss Mary and Mr Smith as their courses have expired past 2 years.
Any help is much appreciated!
KJM