Basically, you need one click event for each button.

It is possible to generate and control buttons from within a class module, but
that's an advanced topic.

As a matter of design, you shouldn't have a need for multiple buttons that do
almost the same thing - especially 100 of them. What are you trying to do?