question regarding pasting controls

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system so
subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.
 
One work around is to name them with consecutive numbers. But it seems like
there is a way to reset the index numbers also. I am sure there is on a
form, and I would think you could do it on a sheet also.
 
thanks, but i don't get to name them, they get pasted from a browser window.
control 8 is always an embedded filed i need, but the next time the user
pastes from the browser, there is no control 8, as it starts number from the
last control that was pasted.

i have absolutely no control over this, it's some old unix system that works
through a browser window and i'm just trying to help the person out with
capturing some data. they know it needs to get replaced, but who knows when
they'll do it.
 
Is there a way to capture the last control number and use a variable that
represents the next number instead of the control #8? Or is it closed code
that you can't modify?
 
not sure, they'll just have to exit excel and restart it.

thanks for the response.
 
There is no way to reset the object identifier that automatically gets
incremented and appended to newly added objects, at least not while any
objects exist on the sheet.

Rename controls perhaps.

Regards,
Peter T
 
Back
Top