What is the difference in declaring a Collection in these Procedur

  • Thread starter Thread starter RyanH
  • Start date Start date
R

RyanH

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Howto declare and fill a custom collection of worksheets ? 6
Enable Property of Multipage Control Pages = CheckBox.Value 2
Change the value of particular cells in a Named Range 7
Do I need to destroy a collection I made when I am done with it? 5
How can I use a collection inside a class? 7
Run time error 91 when trying to add controls to a collection 3
Problems in copying a Collection to another and removing elementsfrom two Collections 6
424 Error whem trying to change Visible property 2

Back
Top