Thread
:
Checkbox limitations
View Single Post
#
1
Posted to microsoft.public.excel.programming
Solution4U
external usenet poster
Posts: 10
Checkbox limitations
This appears to be a repeatable problem.
Please advise if there is a fix for this, my email is
Here are the 2 posts from the forum:
"Solution4U" wrote:
I have 5 columns with over 100 check boxes in each. I keep getting an error
when the code runs unless I delete a certain portion of checkboxes. Right
now all is running well with 1195 checkboxes but if I add more I get the
error.
Does anyone know why this is happening or how to get around it?
I was only able to add 1098 check boxes using the code below with Excel 2003.
I could not find any limits listed in the excel help that explains this
problem.
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/13/2008 by Joel
'
'
LeftPos = Range("B1").Left
For RowCount = 2 To 4000 Step 2
TopPos = Range("B" & RowCount).Top
ActiveSheet.OLEObjects.Add _
ClassType:="Forms.CheckBox.1", _
Link:=False, _
DisplayAsIcon:=False, _
Left:=LeftPos, _
Top:=TopPos, _
Width:=108, _
Height:=19.5
Next RowCount
End Sub
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...el.programming
Reply With Quote
Solution4U
View Public Profile
Find all posts by Solution4U