/BASIC/VBA Initialise/Initialize String/Number Array (not variant)

VBA Initialise/Initialize String/Number Array (not variant)

Sub UseStringArray()

    Dim sample() As String
    sample = StringArray("dog", "cat", "horse")

End Sub

Function StringArray(ParamArray ArgList())

    ReDim tempArray(UBound(ArgList)) As String
    For i = 0 To UBound(ArgList)
        tempArray(i) = ArgList(i)
    Next
    StringArray = tempArray

End Function

Source: stackoverflow.com

Similar codes

0 vote159 views2 answers
Dos/cmd equivalent to "head"
BASIC
0 vote237 views1 answer
Add firefox
BASIC
0 vote148 views1 answer
Trollbox
BASIC
0 vote151 views1 answer
Excel vba chck that the range is empty
BASIC
-1 vote142 views4 answers
C++ code to c code converter
BASIC
0 vote139 views1 answer
Split to list vb.net
BASIC
0 vote155 views1 answer
Detailview with form mixing
BASIC
0 vote147 views1 answer
Sequnce function vb.net
BASIC
0 vote139 views1 answer
Theme leaf concatenate
BASIC
0 vote148 views1 answer
Freecodecamp basic algorithm scripting return largest numbers in arrays
BASIC