Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with creating numerous shapes on a single sheet
Hello,
It's an ancient post that didn't get any answer and that I reuse as get the exact same problem. I hope it's the right place for that. Problem is this : from within a macro, i draw textboxes on my excel-sheet using Sheets(sht).TextBoxes.Add(lft, tp, wdth, hght).Select .... everything seems fine, a textbox with the name 'Text nnnnn' i generated, where nnnnn is a sequence number, always increasing by 1. At a certain point (appr 65000), this process fails with error : Run-time error '1004': Select method of Textbox class failed. I assume the process reaches its maximun for this (internal) counte (65000 per sheet). Deleting textboxes does not affect this counter. Also giving this textbox a self-generated name, using ..... Selection.name = "Textbox " & count count = count + 1 .... has no influence on this counter, it only affects the name of th textbox. As this application is frequently used, and generating about on thousand textboxes each time, you'll understand that reaching the point o 65000 happens (to) often. Is there way to manipulate this value from within my macro, or is ther a work-around ???? Help of any kind would be very welcome and appreciated. Thanks ! Youpi Col -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run numerous calculations through a single formula | Excel Discussion (Misc queries) | |||
Creating new worksheets using data from a single sheet | Excel Worksheet Functions | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
Creating shapes from given criteria | Excel Worksheet Functions | |||
creating Shapes | Excel Programming |