Posts by EpicDan

Re: Set ComboBox RowSource to Excel Spreadsheet UserForm Control

I think I may have misread the question...

Re: Set ComboBox RowSource to Excel Spreadsheet UserForm Control

Try This..

This code Populates the ComboBox with Data that is listed in A1 to A8 in Sheet 1

Private Sub UserForm_Initialize()
With ComboBox1
.List = Sheets(1).Range("A1:A8").Value
End With
End Sub