Arrays and Split()

[Michael42]

If using an array created via a Split() do I need to ReDim it if every time I use it as shown below? If yes, I have never used ReDim, please give example using below context.

Many Thanks!!!


'ComboBox Control Test
isComboDBField = false
for n = 1 to UBound(aComboTables)
aComboTemp = Split(aComboTables, ",&quot
if aComboTemp(0) = aFieldNames(i) then
isComboDBField = true
exit for
end if
next

 

[JohnYingling]

' No need to redim. But you can get array with UBound = -1
MsgBox Cstr(Ubound(Split("",",&quot))' 0-length entry
for n = 1 to UBound(aComboTables)
aComboTemp = Split(aComboTables, ",&quot
if Ubound(aComboTemp) >= 0 then
if aComboTemp(0) = aFieldNames(i) then
isComboDBField = true
exit for
end if
End if
next

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[Michael42]

Great, thanks for the advice and confrimation on this.