Hi,

Is there any way for all command buttons in a document to execute the same code.
The document contains 40 command buttons in a table, but all command buttons in each row execute a userform1.show code.

Is there an easier way to make this happen instead of having 40 separate lines of code for each command button.

I've seen the class module method for a userform but not sure how to get it done when the command buttons are within a document instead.

Thanks