I have a self-contained, multi-spreadsheet workbook used to create annual budgets. One of the worksheets is more of a form with literally thousands of Option Buttons (radials) and Group Boxes. (The Form Controls are intended as a visual aid for the User with calculations based on the resultant numerical output.) To help myself keep track, I've gone through and named/grouped all of the thousands of objects.
My question to the senseis out there: Is there any way to extract the object names and/or tree from the Selection Pane into a list? For example,
- Row1Group
---- RaiseGroup1
------- Amount1
------- Percentage1
---- RaiseGroup2
------- Amount2
------- Percentage2...etc.
Bonus questions: I dislike naming objects/ranges/cells as I find cell references easier to manage, but in this case it is a necessary evil...anyone know generally how much I am slowing myself down (size, processing, etc.) by naming all of these objects? (I believe my workbook would be closer to 100KB than 1MB without all of the named objects, but not sure.)
Thanks for any help.
My question to the senseis out there: Is there any way to extract the object names and/or tree from the Selection Pane into a list? For example,
- Row1Group
---- RaiseGroup1
------- Amount1
------- Percentage1
---- RaiseGroup2
------- Amount2
------- Percentage2...etc.
Bonus questions: I dislike naming objects/ranges/cells as I find cell references easier to manage, but in this case it is a necessary evil...anyone know generally how much I am slowing myself down (size, processing, etc.) by naming all of these objects? (I believe my workbook would be closer to 100KB than 1MB without all of the named objects, but not sure.)
Thanks for any help.
Last edited:
