Text Box numbering

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Question: If i generate 100 textboxes on a sheet then delete them...the next texbox is numbered #101. How can I reset the numbering back to #1?

    Situation: My code generates a number of textboxes on a sheet, allows the user to view & print, deletes the textboxes, moves to the next record and repeats on the same sheet.
    After 100 records I am over "Text Box 1000". If I do this weekly then I'll be over "Text Box 1000000"


  • Thank you Dennis & Ivan. I hadn't thought of explicitly naming them..that way I can blow them away and use the same names again on the next iteration.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!