# of labels limitation?

TAPS_MikeDion

Well-known Member
Joined
Aug 14, 2009
Messages
622
Office Version
  1. 2011
Platform
  1. MacOS
Is there a maximum number of labels you can use on a form?

Suddenly I cannot put any more labels on my form. I'm at around 35. Every time I either try to copy and paste a label or create one from scratch from the Toolbox I get the following errors:


From the Toolbox:
"Could not complete the operation due to error 8002802C"

Copying and pasting an existing label:
"Could not paste the control. Could not complete the operation due to error 8002802C"


I can add other objects, just no additional labels.

Any ideas?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
I've no idea if there's a limit or not, but it will be above 35. I've seen code where people have had over 100 labels.
 
Upvote 0
are you running any codes besides VBA with this? SQL?
 
Upvote 0
Yeah, I didn't think 35 was that high anyway.

No Blake, just VBA.

I'm going to try a re-boot for the heck of it.
 
Upvote 0
According to a search on Google, that error (8002802C) appears to be related to an ambiguous name. Do you have more than one object with the same name?
 
Upvote 0
Don't know what happened. I didn't have any duplicate label names, but after a re-boot everything worked ok again.

Thanks for the help everybody!
 
Upvote 0
Glad it's working & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,212
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top