1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

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

[Solved] VBA Initialise/Initialize String/Number Array (not Variant) | Basic - Code Explorer | yomemimo.com
Question : VBA Initialise/Initialize String/Number Array (not variant)

Answered by : plamen-grozdanov

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 : https://stackoverflow.com/questions/19369132/declare-and-initialize-string-array-in-vba?answertab=active#tab-top | Last Update : Tue, 14 Sep 21

Answers related to VBA Initialise/Initialize String/Number Array (not variant)

Code Explorer Popular Question For Basic