Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General question: how many controls allowed?
I looked in the Excel/VB help, but couldn't find the answer to thi
question: How many form controls can be placed on a worksheet? Or i there any limit other than that imposed by the computer' memeory/storage -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
General question: how many controls allowed?
i've just tested and it depends..
the NATIVE controls from forms toolbar.. you can easily add 10000 controls. if you're talking about embedded ole controls i wouldn't do it... look at your temp directory after running macro below :) Sub DontUseManyOleObjects() Const max = 500 Dim i% Workbooks.Add Application.EnableEvents = False Application.ScreenUpdating = False 'with ActiveSheet.CheckBoxes.Add(5, 1, 72, 18) With ActiveSheet.OLEObjects.Add(ClassType:="Forms.Check Box.1", _ Link:=False, DisplayAsIcon:=False, _ Left:=100, Top:=1, Width:=108, Height:=18) For i = 1 To max With .Duplicate .Top = ActiveSheet.Cells(2 * i, 1).Top End With Next End With Application.EnableEvents = True Application.ScreenUpdating = True End Sub keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Mekratrig wrote: I looked in the Excel/VB help, but couldn't find the answer to this question: How many form controls can be placed on a worksheet? Or is there any limit other than that imposed by the computer's memeory/storage? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
General question: how many controls allowed?
I think you answered your own question about memory
-- Don Guillett SalesAid Software "Mekratrig " wrote in message ... I looked in the Excel/VB help, but couldn't find the answer to this question: How many form controls can be placed on a worksheet? Or is there any limit other than that imposed by the computer's memeory/storage? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A VERY General question | Excel Worksheet Functions | |||
General Question | Excel Discussion (Misc queries) | |||
General Question | Excel Discussion (Misc queries) | |||
General Question | Excel Worksheet Functions | |||
General Question | Excel Programming |