Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the difference in declaring a Collection in these Procedur
Can someone tell me the difference in these two subs, if any difference at
all? Sub BuildCollections() Dim colAssignedDepts As Collection Set colAssignedDepts = New Collection With colAssignedDepts .Add chkEngineering .Add chkGraphProd ' add other checkboxes End With End Sub Sub BuildCollections() Dim colAssignedDepts As New Collection With colAssignedDepts .Add chkEngineering .Add chkGraphProd ' add other checkboxes End With End Sub -- Cheers, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the difference in declaring a Collection in these Procedur
Ryan,
If you google things like ' "as new collection" "as collection" including: http://discuss.fogcreek.com/joelonso...w&ixPost=24747 http://groups.google.com/groups?q=%2...L_enUS250US250 http://www.dailydoseofexcel.com/arch...ult-instances/ hth, Doug "RyanH" wrote in message ... Can someone tell me the difference in these two subs, if any difference at all? Sub BuildCollections() Dim colAssignedDepts As Collection Set colAssignedDepts = New Collection With colAssignedDepts .Add chkEngineering .Add chkGraphProd ' add other checkboxes End With End Sub Sub BuildCollections() Dim colAssignedDepts As New Collection With colAssignedDepts .Add chkEngineering .Add chkGraphProd ' add other checkboxes End With End Sub -- Cheers, Ryan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the difference in declaring a Collection in these Procedur
check out chip pearson's site
Don't Use The New Keyword In A Dim Statement http://www.cpearson.com/Excel/variables.htm -- Gary "RyanH" wrote in message ... Can someone tell me the difference in these two subs, if any difference at all? Sub BuildCollections() Dim colAssignedDepts As Collection Set colAssignedDepts = New Collection With colAssignedDepts .Add chkEngineering .Add chkGraphProd ' add other checkboxes End With End Sub Sub BuildCollections() Dim colAssignedDepts As New Collection With colAssignedDepts .Add chkEngineering .Add chkGraphProd ' add other checkboxes End With End Sub -- Cheers, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
declaring | Excel Programming | |||
Declaring a collection as a particular type of object or a particular class | Excel Programming | |||
How to use Excel VBA program to execute SQL SERVER stored procedur | Excel Programming | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel |