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.
|