You don't need to write them. Just double click the buttons (in design mode)and Excel will create them for you. All you need to do is add the singlesubroutine call line to each that passes the button number to a commonprocessing routine.