Unanswered: Using a combo box as an array item in VBA
I'm having a brainfade moment. I have a collection of combo boxes that I want to use in a loop to say that if the combo box is not empty then run the function then move onto the next combo box. I can't for the life of me remember how to do it.
Here's my code so far - I know this is wrong, but can't remember or find the right code.
All help will be much appreciated.
Dim strTable As String
Dim strFolderName As String
Dim strFileName As String
Dim strSheet As String
Dim str_sheet As String
Dim strPath As String
Dim j As Integer
Dim i As Integer