View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default 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?