Text Box numbering

  • 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!