Text Box numbering

Egad · Jan 31st 2003

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"

:o

XL-Dennis · Jan 31st 2003

Egad,

Instead of deleting the textboxes why don´t You just loop through the collection and make them invisible?

Kind regards,
Dennis

Ivan F Moala · Feb 1st 2003

Further to Dennis suggestion

IF you must create the Textboxs then Explicitly name them with an Index and loop through to delete them.

Egad · Feb 1st 2003

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.

Text Box numbering

Participate now!

Share