ArrayList Compile Error user defined type not defined

[drop05]

Hello, i am getting an error, compile error: user defined type not defined
i am not sure why this is happening
getting it in this code at this part of the code:

tblTabsImport As ArrayList

Code below:

Private Sub CommandButton2_Click()

Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
Application.DisplayAlerts = False

'Getting arrayList of tabs to import
'
'Dim tabsToImport As ArrayList
'Set tabsToImport = New ArrayList

Dim tblTabsImport As ArrayList
Set tblTabsImport = New ArrayList

Dim wb As Workbook
Set wb = Workbooks.Open(fileName:=Me.TextBox1.Text)

Dim i As LongPtr
Dim tempSht As Worksheet

Dim lo As ListObject

For i = 0 To Me.ListBox1.ListCount - 1
    If Me.ListBox1.Selected(i) = True Then
        tblTabsImport.Add Me.ListBox1.list(i)
    End If
Next i

For i = 0 To tblTabsImport.count - 1
    wb.Worksheets(tblTabsImport(i)).Copy After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.count)
Next i

On Error Resume Next
ThisWorkbook.ChangeLink Name:=wb.Name, NewName:=ThisWorkbook.Name
On Error GoTo 0

Unload Me

Application.ScreenUpdating = True
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True


End Sub

 

[jasonb75]

Shouldn't it just be
Dim tblTabsImport As New ArrayList
Using Set seems a bit wrong as you will be adding items to a list, I'm no expert on the specifics of ArrayList but I'm fairly sure you just need to declare it at the start.

Edit:- quick check on some ArrayList info, as far as I can see you need to 'Set' it to an object variable if you're using late binding. If you're using early binding then the line above should suffice.

 

[RoryA]

Declaring As New is generally regarded as bad practice, but I think the main issue here is that you need a reference to the mscorlib library (if I remember correctly) to use objects from the .net runtime.