Embedded Objects in EXCEL spread sheet
I have created objects through VBA. ListBoxes and CheckBoxes.
When creating them I have named them, but the code for .CreateEventProc will
not recognize the name in which I have assigned. It will read "CheckBox1"
but not "wkCheck6". I am cycling through loops and I need to use the renamed
value for the name. Do I have to enumerate then object after it is named in
some fashion?
Thank you for any help.
|