What is the new object name after copying & inserting line?
 

I have some code that copies a line and inserts a new one. It also
(correctly) copies a checkbox and add a new one, but the linked cell
is now incorrect.

Question: How do I find the name of the new checkbox in order to be
able to change the linked cell?

What is the new object name after copying & inserting line?
 

Use the count of checkboxes as the new checkbox index.
Something like: .Checkboxes(.Checkboxes.Count).LinkedCell
(for illustration purposes only, not actual code)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)

..
..

"Khuli"
wrote in message
...
I have some code that copies a line and inserts a new one. It also
(correctly) copies a checkbox and add a new one, but the linked cell
is now incorrect.

Question: How do I find the name of the new checkbox in order to be
able to change the linked cell?

What is the new object name after copying & inserting line?
 

Thanks Jim - that worked perfectly!


On 19 Oct, 13:01, "Jim Cone" wrote:
Use the count of checkboxes as the new checkbox index.
Something like: *.Checkboxes(.Checkboxes.Count).LinkedCell
(for illustration purposes only, not actual code)
--
Jim Cone
Portland, Oregon *USAhttp://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)