Re: Create Multiple Buttons All Assigned To Macro Code
I apologize for the confusion, but I did explain my problem in more detail in the original post. I'm not familiar with the activecell approach, but my idea is to make my spreadsheet as user friendly as possible. I want the user to be able to check the box and upon doing so, a macro would run to automatically copy and paste the values of the cells in the row in which the check box is situated. I need to run a macro first though to create a lot of these checkboxes (over 500). The primary purpose of the checkbox (as far as the user would be concerned) would be to represent whether a particular condominium is under contract or not. I hope this adds some clarity to my question. Thanks.