Excel -- checkboxes
Experts:
Please find attached a sample spreadsheet that utilizes "check boxes" (with their controls linked to associated cells).
I need to find another way that allows me to use checkboxes; however, I don't want to manually update the controls/links for hundreds of checkboxes.
Do you know of another way to mimic this process? Again, please find attached XLS for more details on the problem/requirement.
Thanks,
EEH
Check-Box-Formulas.xlsx
Please find attached a sample spreadsheet that utilizes "check boxes" (with their controls linked to associated cells).
I need to find another way that allows me to use checkboxes; however, I don't want to manually update the controls/links for hundreds of checkboxes.
Do you know of another way to mimic this process? Again, please find attached XLS for more details on the problem/requirement.
Thanks,
EEH
Check-Box-Formulas.xlsx
Martin Liss
What do you want to "manually update" and would a macro solution be OK?
ASKER
Martin:
I'd like to copy/paste row 1 and update, e.g., rows 2 through 300 with checkboxes which have individual controls (vs. all of them linked to the same cell).
EEH
I'd like to copy/paste row 1 and update, e.g., rows 2 through 300 with checkboxes which have individual controls (vs. all of them linked to the same cell).
EEH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow... that's the PERFECT solution!!!!! Thousand thanks for it!!! :)
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you
including these two new ones.
Creating your own Excel Formulas and doing the impossible
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you
including these two new ones.
Creating your own Excel Formulas and doing the impossible
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014