Returns an array from function vba

Function arrayOfPiDigits() As Long()

	'Add parenthesis after the data type
    Dim outputArray(0 To 2) As Long
    
    outputArray(0) = 3
    outputArray(1) = 1
    outputArray(2) = 4

    arrayOfPiDigits = outputArray
    
End Function

Source: riptutorial.com

Similar codes

0 vote137 views1 answer
Vba multiple optional arguments
VBA
3 votes131 views1 answer
Excel vba change format of cell
VBA
4 votes128 views1 answer
Vba create directory
VBA
0 vote113 views1 answer
Vba apostrophe chr
VBA
0 vote121 views1 answer
Vba text to general
VBA
0 vote113 views1 answer
Vbnet get file name from path
VBA
1 vote121 views1 answer
Excel vba first row in range
VBA
1 vote86 views1 answer
How to open cmd with vbd
VBA
0 vote129 views1 answer
Group controls programmatically vb
VBA
0 vote132 views1 answer
Test if form is open vb
VBA