Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I searched as best I could, but couldn't find anything on the
subject. Hopefully someone out there has an answer or knows where one is. I'm writing a wrapper for arrays of strings to make my life down the road easier (working on a large-ish scale data analysis project with a _lot_ of string comparison, sorting, adding, and removing). Right now, the following works: Public Sub Test() Dim sArray As New StringArray sArray.AddItem("A") sArray.AddItem("B") sArray.AddItem("C") For i = 1 to sArray.Count Debug.Print sArray.Item(i) Next i End Sub I'd like to be able to use sArray(i) instead of sArray.Item(i), but can't find anything on it. I tried using the NewEnum hack for Collection wrappers, but VBA doesn't seem to agree with me that it should work about the same. Any suggestions? (In case it helps, StringArray contains a Private p_strArray() As String) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question: Can't pass an Array to a class | Excel Programming | |||
Problems Setting properties of class module | Excel Programming | |||
Multidimensional Arrays as Properties in Class Files? | Excel Programming | |||
Custom Class and Properties | Excel Programming | |||
class modules and array | Excel Programming |