Excel Checkbox Dilemna
March 4, 2010 9:22 AM Subscribe
Excel Checkbox Question. Please help me write a macro that will selectively uncheck certain boxes within a named range. This has driven me crazy all day today.
posted by kev23f to computers & internet (5 answers total)
So i have a row of 7 checkboxes, inserted using “Insert – Form Controls” dialog in excel 2007.
Each checkbox sits above a cell, and each checkbox has been formatted so that it has a “cell link” to the cell directly beneath it.
The checkboxes are not grouped or anything, they are all separate.
I have several rows of checkboxes similar to this.
I would like to create a macro that when run, will uncheck all the boxes that are within a certain range, for example, from A1 to G1.
I have found VBA that will clear all checkboxes on a sheet, but the key for me is to be able to specify which checkboxes get cleared when i run the macro.
I am a total macro newbie so please be gentle.