collection

Im looping a range of cells in column A. If it meets a certain criteria need to copy that whole row. Instead of individually copy and pasting the row everytime i loop when the if statement is true i want to keep adding that row to an array, collection or whatever is a better solution and once...

Hi The code below is going to run no problem to my surprise. It will also run without typing Application. Now I am confused. I know to access a workbook I need to go through the workbook collection like the following msgbox(application.workbooks(1).name) So why the code below is OK? Thank...

This code checks the version of Excel installed: Option Explicit Sub Test() Dim abc As Collection Set abc = New Collection abc.Add Module2.Version abc.Item (0) ' FAILS HERE End Sub Option Explicit Public Function Version() As Collection...

Dear Excel Experts, I have a simple piece of VBA code with some (messy) error handling that builds a collection by constructing a string and seeing if it exists in a larger collection. This code generates an application execution error on the second pass through the for next loop. Private...

Hello All, I have one userform on which I have a multi pahe. Each tab of multi page has 4 text boxes in column format . Each column having two text boxes. At the bottom of the user form, there are three command buttons (Next Page, Cancel and Close). All controls are added to a collection and...

Hello Everyone, I have a Multipage that is generating new pages with various CheckBox, ComboBox, TextBox and Button objects. Currently I'm just focusing on the CheckBox objects but the same code will applied for every different objects. I know that all 5 CheckBox objects are added to the...

Hi , can anyone help me with below query. i have a collection of arrays. and i need to read the values. eg: Dim resColl As New Collection resColl.Add Array(key, Key3("UserName"), Key3("Password")) in above add method i added arrays with 3 elements. and after adding i need to read the...

I am trying to use the following code to open a pdf file from a folder, but I keep getting the "File not found" error. Shell "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Adobe Acrobat DC.exe " & FullPath & """, vbMinimizedFocus" Is there something I am missing? Below if the whole...

Hi, as I am new on this Forum, I don't know if my question has already been posted. If yes, please just show me which post. I have a collection with n classes (Batch) and I like to change attributes of the items. These attributes are strings like (Name, Adress, Phone, etc...) A create a GUI...

Hi, 1: I have an Access DB that I use to copy Worksheets X, Y, Z from WorkBook 1 to WorkBook 2 (WorkBook 2 already has Sheets (A, B & C). objWBSource.Worksheets("MySheetName").Copy Before:=objWBDest.Sheets(1) 2: I save and close both WorkBooks. 3: WorkBook 2 then has sheets A, B & C and the...

I did find a most beautiful macro somewhere in the net making it possible for me to just make a selection and it would make the unique values in the selection go to the clipboard sorted It worked fine in Excel 2010 but stopped working in Excel 2014. I get no sensible output , just ￿￿ Could...

Hi, I am new in data scrape via VBA. I want to get my order history over amazon. I can get all the info from html table with the code below. However, this code gives td elements in a single and it is hard to parse it again. I attached the html code of web page and highlight the info I want...

Currently my array brings up three different msgboxes, as shown with the Functions 'Expired', 'Expiring', and 'NoTraining'. The array msgboxes display information based on whether a date is Expired (older than current date), Expiring (within 31 days), and is a date is missing (NoTraining). No...

Currently my array brings up three different msgboxes, as shown with the Functions 'Expired', 'Expiring', and 'NoTraining'. The array msgboxes display information based on whether a date is Expired (older than current date), Expiring (within 31 days), and is a date is missing (NoTraining). No...

I am trying to remove empty elements from a Collection. Here is the code I have so far. Sub T() Dim i As Integer Dim Altered As New Collection Altered.Add Range(Cells(12, 2), Cells(19, 12)).FormulaR1C1 For i = 1 To Altered.Count If Altered.Item(i) = "" Then Altered.Remove i...

I have a collection with a custom class and I don't know how to print the items in the collection. Can someone help me? The collection = datacollection. The class = bobjclass class variables = country name, Amount, Account, Account name.

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...

Hopefully some Excel VBA guru can help me on this :-) I need a solution for the case below that I plan on using for an application I'm developing: Case: A sheet can have an Autofiltered Range and many Autofiltered Tables(ListObjects). Requirement: I need VBA code which can identify these...

I have multiple links between spreadsheets, one in particular uses a data validation drop filter menu which when changed from one week to another, it should update the information it gathers, which it does, provided I have the source sheet open. Is there a way around this, so that I don't need...

Hi! I found a code on Stackoverflow (3. comment): https://stackoverflow.com/questions/33902129/count-the-most-frequently-used-words-in-an-excel-column-containing-a-lot-of-text But I can't use, because if I add a "Set RangeToCheck= Range("A1:A4") it doesn't work. If i click the "run" button, it...