Avatar of ExpExchHelp
ExpExchHelp
Flag for United States of America asked on

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
Microsoft ExcelVBA

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

What do you want to "manually update" and would a macro solution be OK?
ExpExchHelp

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
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ExpExchHelp

ASKER
Wow... that's the PERFECT solution!!!!!   Thousand thanks for it!!!  :)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Martin Liss

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