collection object

  1. S

    A week of struggling to covert an ActiveSheet.comments collection into a 2D array

    Afternoon everyone, I'll try and keep this short and unambiguous. I have a spreadsheet with pupils names (rows) and the subjects (columns) they are struggling in (I'm a teacher). The final column counts the number of notes for each pupil (row). I did manage to write a quick subroutine that...
  2. K

    Use collection to store class objects

    Hello I want to use a collection that contains different car objects. I'm familiar to do this in Java but I don't find the solution in VBA. I want to create a class car where I can create my car object with contains the following parameters make model year therefore I have to make a class...
  3. jcoleman25

    Adding User Input to a collection (path of folder they want to search), then looping through each item with For-Each.

    I'm having a hard time getting this collection thing down. What I want this code to do is take the user input as a string and store it for use later when the For-Each code is run. I'm not having any luck so far and its probably because I'm having trouble wrapping my head around the concept...
  4. M

    Populating Textbox from Collection Object

    Hi all, Is there a way to populate a TextBox on a form, to show a correct row value, by using the collection index that is being used to populate a Comboox ? I’m trying to bypass the ten column limit.<o:p></o:p> <o:p> </o:p> <o:p> </o:p> On a user form:<o:p></o:p> <o:p> </o:p>...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top