Is there a quick lookup function in VBA? I have an array defined as
Type newtype
code as string
value as integer
end type
DIM testarray as newtype
Code is "A".."Z"
Is it possible to do something like this in VBA testarray("A").value? or Do
I need to loop through the array until I find the code "A" and then get
testarray(i).value.
Thanks
Bookmarks