Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Draw on top of embedded objects in Excel 2007 | Excel Discussion (Misc queries) | |||
Editing problems with embedded Excel objects | Excel Discussion (Misc queries) | |||
Can't open embedded .msg objects in Excel. Help! | Excel Discussion (Misc queries) | |||
Adding Embedded OLE Objects on a Spread Sheet | Excel Programming | |||
Embedded Objects in Excel | Excel Programming |