Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Draw on top of embedded objects in Excel 2007 mwoolf Excel Discussion (Misc queries) 0 October 13th 09 12:59 PM
Editing problems with embedded Excel objects Andre Excel Discussion (Misc queries) 0 June 11th 07 09:46 PM
Can't open embedded .msg objects in Excel. Help! Tkn Excel Discussion (Misc queries) 0 December 14th 06 12:22 AM
Adding Embedded OLE Objects on a Spread Sheet James McDowell Excel Programming 12 April 19th 05 10:47 PM
Embedded Objects in Excel Lonely[_4_] Excel Programming 0 December 15th 03 01:20 PM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"