Hi,
I hope someone could help with VBA code to populate a list box on a user form that gets the it's data from another sheet (DB) with all the data in a table. sheet attached
I need two things to happen with this user form:
1. When the All Staff button (Grey button) is pressed on the user form then the list box (Resultbox) must get populated with staff detail of the following columns: Name, Last Name, Branch, Cell Number for ALL the staff listed on sheet (DB).
2. When the Current Staff button (Blue button) is pressed on the user form then the list box (Resultbox) must get populated with staff detail of the following columns: Name, Last Name, Branch, Cell Number for only the staff that are currently employed and this is determined by column N which says if they are employed or not.
Thanks
Bookmarks