Hi, I currently have a spreadsheet that has a large number of seperate cells that I manually change colour depending on what month it is, what I want is a button that will change all the cells a specific colour depending on what month of the year it is (so that I don't have to go and change each cell separately, which is what I do at the moment and is very time consuming) I currently have a user form that has a colour palet with a button that edits the colour and a button to apply the colour to a number of cells, the problem I have is that when you click the apply button the cell colour is unchanged. Please could someone help me?
The following code is set as the code for the User form:
And the Following code is used in a class module:
I would be very grateful if someone could help me with this.
Bookmarks