I have a property management workbook that has a summary sheet with several rows of buttons on it. Press one of the buttons and it creates a summary bill, taking data from each of the monthly sheets and creating the summary.
Right now the code is placed in each button's Click subroutine. I have 57 tenants, so I have 57 Click subroutines, each of which looks like this:
[VBA]Private Sub CommandButton1_Click()
Tenant = 1: SpaceNum = "1"
Call ReconcileSubroutine(Tenant, SpaceNum)
End Sub[/VBA]
This is extremely cumbersome. Is there a way to put the buttons in an array so that I can just call the one I need right from the button push? Thanks. Dave