Hi-
Here my set up on sheet1:
Column "A" has a list of names(rows 1-50)
Column "B" has a list of dates next to each name that refers to that persons starting date of employment.
Column "C" has a list of dates that refers to that persons end date of employment.
Now lets assume that all fifty cells in column "A" are filled with names (employees) and all employees have a start date in column "B". However only 40 employees have an end date listed next to there name in column "C". That leaves you with 10 "active" employees who still are employed. On sheet1 these 10 people that are still active have no end date in column "C" listed in the same row as there name and those names are not one after the other.ex:
column "A" column "B" column "C"
John 26 feb 02 13 mar 02
Andy 28 feb 02
Jason 1 mar 02 12 mar 02
Steven 2 mar 02 13 mar 02
Eddy 2 mar 02
Jean 7 mar 02 20 mar 02.....
Now my question is, using a list box on a userform How do you set the row source property in code to only show the "acvtive" employees. This list on sheet one is always being updated w/ new employees(column "A") and end dates(column "C"), so there for once an employee is asigned an end date, The name can not show on the listbox. By the way, the only column to be shown from the list box is column "A", there name. I hope someone understands this-
thank you- Todd
Here my set up on sheet1:
Column "A" has a list of names(rows 1-50)
Column "B" has a list of dates next to each name that refers to that persons starting date of employment.
Column "C" has a list of dates that refers to that persons end date of employment.
Now lets assume that all fifty cells in column "A" are filled with names (employees) and all employees have a start date in column "B". However only 40 employees have an end date listed next to there name in column "C". That leaves you with 10 "active" employees who still are employed. On sheet1 these 10 people that are still active have no end date in column "C" listed in the same row as there name and those names are not one after the other.ex:
column "A" column "B" column "C"
John 26 feb 02 13 mar 02
Andy 28 feb 02
Jason 1 mar 02 12 mar 02
Steven 2 mar 02 13 mar 02
Eddy 2 mar 02
Jean 7 mar 02 20 mar 02.....
Now my question is, using a list box on a userform How do you set the row source property in code to only show the "acvtive" employees. This list on sheet one is always being updated w/ new employees(column "A") and end dates(column "C"), so there for once an employee is asigned an end date, The name can not show on the listbox. By the way, the only column to be shown from the list box is column "A", there name. I hope someone understands this-
thank you- Todd