Fill in holiday dairy using userform using dates

[Alpacino]

I'm trying design a userform so that the user can input a holiday for an employee.
E.g
If employee 1 is off on august 1st for 5 days I would like to put in august sheet Monday "H" tues "H" up to Friday

Each month is in a sheet employees names going down the rows with dates in the month along the columns.

Every sheet is set out the same just dates changing.
I've got an idea on how to design the userform but how do I find the cell address to input "H" against the employee 1.

 

[VoG]

Try this http://www.itv.com/TVGuide/default.aspx

 

[Alpacino]

Hi VoG,

Sorry I don't understand. Are you referring to the lay out??

 

[VoG]

I have no idea how that happened

I meant http://www.fontstuff.com/vba/vbatut07.htm