I am using Microsoft Excel 97 VBA in order to streamline data requests.
Brief discription of what I am trying to accomplish:
After the user selects a data category, My VBA application creates checkboxes identifying all the data fields available in that category. The requestor can then use the checkboxs to identify their data requirements. If the requestor double clicks the checkbox, data selection criteria can be added. This is then saved to an Excel spreadsheet and emailed to the appropriate person.
My problem:
Using the withevents, I can only access the double click event of the last checkbox created. I am creating anywhere from 5 to 200 checkboxes, depending upon the category selected. I have not been successfull in creating control arrays in VBA. Any suggestions.
