How to reference variables from another macro

[Fernando14]

I am trying to store values from one macro into another. Here is the macron that obtains the values:

Sub Flags()
'
' Flags Macro
'
Dim FLAGNUM, i As Integer
FLAGNUM = InputBox("How many flags are there?")
ReDim FLAGSW(FLAGNUM), FLAGSL(FLAGNUM) As Double
ReDim FLAGSNORP(FLAGNUM) As String
For i = 1 To FLAGNUM
    FLAGSW(i) = InputBox("What is flag " & i & "'s width?")
    FLAGSL(i) = InputBox("What is flag " & i & "'s length?")
    FLAGSNORP(i) = InputBox("Is flag " & i & " nylon or polyester? (Enter N or P)")

Next i

'
End Sub

I have tried using the Call command in my second macro but I get errors. I have read about using public variables, but I am not sure how they work. So in my second macro (Sub GetFlags()), how would I reference FLAGSW and FLAGSL? Any help is appreciated

 

[Joe4]

You have two options:

1. Declare and use public variables
See: VBA Public Variables

2. Use parameters to pass them from one module to another
See: Pass Variables Between Macros — Excel Dashboards VBA