Format with different colors

[enfantter]

Hey all,

I've made this excel sheet where its possible to enter periods where people have vacation.
The problem is that i would like to alternate the code in such a way that when pressing different buttons (which are colored in different colors) the formating in the calender should be the corresponding color.
does this make sense?!

[Bob Phillips]

Don't you already get that by selecting the cells and then clicking the fill colour button?

[enfantter]

well im trying to do it trough the userforms..
so i want to combine a userform with a colour witch then is kept in the module ..