Embedded Objects in EXCEL spread sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Monthly Spread sheet. 12
Looping through checkboxes 5
Excel Disallow movement of embedded PDF 2
Deriving a name from variables 2
Adding Embedded OLE Objects on a Spread Sheet 12
Need help in VBA for embedded object in excel 1
SPREAD SHEET FORMULA 2
Find All Embedded Objects in Workbook 9

Back
Top