View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Embedded Objects in EXCEL spread sheet

James,

see the original thread, I think your code was failing after creating, and
before naming.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"James McDowell" wrote in message
...
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.