I'm having some trouble figuring out what the best method is to count items in VBA.
Recently, I received some help from members in implementing an Employee Search using VBA to help me find employees on a list. Specifically, this list is being used to track the number of Paid Personal Time each employee has. Currently, each employee has 4 days per year (represented by 4 separate columns in my spreadsheet). As a holiday is used, we enter a date into the previously blank cell of that column.
Basically, what I would like to happen is this. After searching for an employee, Excel selects the employee name that matches the search. I would then like run a count of the next four columns, same row as active cell. If 4 dates have been enterred (meaning all 4 holidays have been used), I would like a msgbox to popup, indicating that this employee has no holidays remaining.
What is the best way to do this?
Bookmarks