A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem with the counter of shapes



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2004, 12:57 PM
Youpicola
external usenet poster
 
Posts: n/a
Default Problem with the counter of shapes

Hello,

It's an ancient post that didn't get any answer and that I reuse as I
get the exact same problem.

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' is
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) counter
(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 the
textbox.
As this application is frequently used, and generating about one
thousand
textboxes each time, you'll understand that reaching the point of
65000
happens (to) often.

Is there way to manipulate this value from within my macro, or is there
a
work-around ????

Help of any kind would be very welcome and appreciated.

Thanks !


---
Message posted from http://www.ExcelForum.com/

Ads
  #2  
Old August 12th, 2004, 01:20 PM
Rog
external usenet poster
 
Posts: n/a
Default Problem with the counter of shapes

Hi

I don't think there is a way to manipulate excel's counter
such that you can add more text boxes. As to workarounds,
i'd look seriously at whether you need 65000 textboxes on
the sheet ...

Rgds

Rog

-----Original Message-----
Hello,

It's an ancient post that didn't get any answer and that

I reuse as I
get the exact same problem.

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' is
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) counter
(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 the
textbox.
As this application is frequently used, and generating

about one
thousand
textboxes each time, you'll understand that reaching the

point of
65000
happens (to) often.

Is there way to manipulate this value from within my

macro, or is there
a
work-around ????

Help of any kind would be very welcome and appreciated.

Thanks !


---
Message posted from http://www.ExcelForum.com/

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Instances problem Jordan Using Forms 1 July 19th, 2004 03:21 PM
Big Problem. We need the fix Captain K Calendar 0 July 8th, 2004 04:50 PM
Passport Logout Problem Chen qiang New Users 0 May 4th, 2004 09:26 AM
Help Microsoft? WORD11.ADM File Problem Line 818? Dwight Hutchinson New Users 2 May 3rd, 2004 08:25 PM
Word 2000 footnote problem: footnotes consistently too high (again) Lori Formatting Long Documents 2 May 1st, 2004 07:15 PM


All times are GMT +1. The time now is 02:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.