ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Format Control on large number of check boxes (https://www.excelbanter.com/excel-worksheet-functions/145355-format-control-large-number-check-boxes.html)

Daesthai

Format Control on large number of check boxes
 
When copying cells with functions, excel will automatically increment cell
IDs within the functions.

Is there a similar ability for checkboxes? I'm inserting a large number of
check boxes that affect conditional formatting. Is there a way to do this
without having to go into the Format Control for each individual checkbox to
set a cell link?

I'm working in Excel 2003, by the way.

Thanks for any help you can provide.


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com