Yes, it is solved...Sorry about not posting solution or using code tags.
I flipped the array the other direction, so that it was 9 tall by 6 wide. (Just because it was easier to enter the info that way for me)
Replaced combo boxes with text boxes.
Added a button to start a Vlookup to populate the questions.
Here is what I added:
Private Sub LoadTopics_Click()
Dim DBA As String
DBA = Me.DBA.Value
Me.Q1.Value = Application.WorksheetFunction.VLookup(DBA, Sheets("Sheet4").Range("g1:l10"), 2, False)
Me.Q2.Value = Application.WorksheetFunction.VLookup(DBA, Sheets("Sheet4").Range("g1:l10"), 3, False)
Me.Q3.Value = Application.WorksheetFunction.VLookup(DBA, Sheets("Sheet4").Range("g1:l10"), 4, False)
Me.Q4.Value = Application.WorksheetFunction.VLookup(DBA, Sheets("Sheet4").Range("g1:l10"), 5, False)
Me.Q5.Value = Application.WorksheetFunction.VLookup(DBA, Sheets("Sheet4").Range("g1:l10"), 6, False)
End Sub
Bookmarks