I am confused by what is a data validation list and hat is a combobox, and why.

You can load the list like so

[vba]

If Not RS.EOF Then
ary = Application.Transpose(Application.Transpose(RS.getrows))
With Range("F1").Validation
.Delete
.Add Type:=xlValidateList, Formula1:=Join(ary, ",")
End With
End If
[/vba]