View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James McDowell[_2_] James McDowell[_2_] is offline
external usenet poster
 
Posts: 29
Default 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.