If you are making your own calendar, then you have 35 buttons for the days, I
imagine (i.e. five whole weeks) plus a few other controls for months, years,
etc. This is nothing like the "100 commandbuttons or more" you said in your
message. Indeed, it is a simple calendar, that many people have probably played
with.

Give proper information when you ask your questions and you will get more
relevant replies. !!!!

The last home-made calendar I say did exactly this. And it did, indeed have
separate click event code for each button. Also, of course, it had code to
change the caption  for each button  to the date it represented.

Excel doesn't offer many alternatives to this - especially for beginners. It is
certainly possible to define a class module which generates and controls the
button for a single day, and you can then create an array of these to form up
your month - but this really is an advanced topic.