userform to count cell colours and display in textboxes

Hey all,

I have a tracker that displays employee holiday/sickness absence throughout the year (indicated by specific colours).

I have a userform that I want to count the number of these specific colours per employee.

I have a attached an example of the workbook:

Basically, I want to be able to select an employee from the combobox1 and it automatically calculate the number of holiday days, sick days or other days the employee has taken throughout the year by counting the colour filled cells..

I found a few code examples that do something similar but require cells to have formula's in them, I'd really like to keep this to the userform rather than cells on the worksheet. Can the following code (which i found on this site) be modified to suit my needs or will i need something more bespoke?

Please Login or Register  to view this content.

Any help is massively appreciated.

Adam

PS: I've asked this question on MrExcel too, i will keep them both updated with responses.

http://www.mrexcel.com/forum/showthr...08#post2666808

Add this to the form:

Please Login or Register  to view this content.