ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need more than 1208 controls per sheet (https://www.excelbanter.com/excel-discussion-misc-queries/59181-need-more-than-1208-controls-per-sheet.html)

mowali

Need more than 1208 controls per sheet
 

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


Chip Pearson

Need more than 1208 controls per sheet
 
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"
wrote in message
...

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





All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com