I have a userform with several command buttons and a calendar. Upon clicking on a date from the calendar, I have code to get the command button# associated with the date. How can I run a loop so that when I click on the date, the associated command button will change color. I want a loop because I don't want to use several If-Then statements since there are over 50 command buttons. Please help.