Answers for "VBA Initialise/Initialize String/Number Array (not variant)"

BASIC

0

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

Posted by: Guest on September-07-2021

Source

Code answers related to "VBA Initialise/Initialize String/Number Array (not variant)"

Code answers related to "BASIC"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#