A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
VBA will execute arrayLoader first, and when this has finished, it will execute YearCombo.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
if I call two subs (one immediately after the other) from a standard sub, how does vba processes the two? Does it go through arrayLoader first and then continues to YearCombo or are they processed simultaneously? I was just trying to understand what "path" vba takes when multiple call operations are written in a sequence. Thanks
Private Sub Workbook_Open()
Dim lngYear As Long, CurYear As Long
CurYear = Year(Date)
counter = CurYear - 2010 'Sets the nummber of years array to be created
With sheetCharts.Shapes("Year Combo").ControlFormat
.RemoveAllItems
For lngYear = 2010 To CurYear
.AddItem lngYear
Next lngYear
.ListIndex = .ListCount 'Set default value of combo box to last value (Current year)
End With
Call arrayLoader Call YearCombo
End Sub
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
VBA will execute arrayLoader first, and when this has finished, it will execute YearCombo.