Hi,
Does anyone know how to go around the limitation of MS Excel, which doesn't let the user, through automation, to create more than 1208 controls (checkboxes, buttons, or combination of two for example) on one sheet??
Thanks much!
Hi,
Does anyone know how to go around the limitation of MS Excel, which doesn't let the user, through automation, to create more than 1208 controls (checkboxes, buttons, or combination of two for example) on one sheet??
Thanks much!
I don't know whether it is possible to overcome the limit, but I
would not use a worksheet where the number of controls even
approaches the limit. I would suggest you rethink your overall
design.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"mowali" <mowali.1zof0a_1133969701.9013@excelforum-nospam.com>
wrote in message
news:mowali.1zof0a_1133969701.9013@excelforum-nospam.com...
>
> Hi,
> Does anyone know how to go around the limitation of MS Excel,
> which
> doesn't let the user, through automation, to create more than
> 1208
> controls (checkboxes, buttons, or combination of two for
> example) on
> one sheet??
>
> Thanks much!
>
>
> --
> mowali
> ------------------------------------------------------------------------
> mowali's Profile:
> http://www.excelforum.com/member.php...o&userid=20886
> View this thread:
> http://www.excelforum.com/showthread...hreadid=491476
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks