Will the For Each statement always be consistent of returning the data? What if I rearrange the Textboxes, will the sequence change?
The For Each will return the controls in the order they were added (if I remember correctly) so physically rearranging them on the worksheet should not change the order


What about is there something like Tabstop where I can assign like with forms??
Don't think so


Is there a better solution that any of you experts can give me?
Suggestion would be to just For Each the OLEObjects, write .Name, .OLEType, .Caption, etc. to another worksheet and then sort

You could add a 'New Name' column to the WS and enter a more meaningful name, write a throw-away macro, and rename the OLE objects