If they are buttons from the control toolbox toolbar, just double click on one
and you'll be in the _click procedure. This code would be under the worksheet
that owns the button.

if they are from the Forms toolbar, then rightclick on it and choose assign
macro. these macros would be in a general module.

Andy wrote:

I am writing VBA to generate user input sheets, within
these I can create command buttons and change the caption
but how do I programatically make this button call a
macro when it is clicked?

--

Dave Peterson