Forum Discussion
Jacqueline28
Jan 26, 2021Copper Contributor
Inserting one checkbox and linking to multiple cells to trigger sums
Hi - I am adding checkboxes that are linked to cells to calculate costs. So far I have one check box per cell. I was wanting to link 1 checkbox to 6 cells so that I can check one box and select them ...
NikolinoDE
Jan 26, 2021Gold Contributor
Jacqueline28
Jan 26, 2021Copper Contributor
Thank you so much for these insights. What is the 10 and 3 referencing in the formula?
Thanks!
- NikolinoDEJan 27, 2021Gold Contributor
What is the 10 and 3 referencing in the formula?
This property specifies a color as an index into the color palette.
Please see the following link where there is also a table with the colors.
ColorIndex property
https://docs.microsoft.com/en-us/office/vba/api/excel.colorindex
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here