hello all, I am a beginner at userform design and trying to get this code to work, in the named range reference on sheet2 I have

=OFFSET(Sheet2!$A$2:Sheet2!$B$2, 0, 0, COUNTA(Sheet2!$A:$A:Sheet2!$B:$B)-1,2) on the user form I have this 

Private Sub UserForm_Initialize()
'Populate combo box.
Dim rngBoProbsOpps As Range
Dim ws As Worksheet
Set ws = Worksheets("Sheet2")
For Each rngBoProbsOpps In ws.Range("BoProbsOpps")
Me.cmbProblemsOpps.AddItem rngBoProbsOpps.Value
Next rngBoProbsOpps
End Sub

Is the problem in the sub? seems like I need something that identifies column1 and column 2.  All the values end up in 1 column.

Thanks for any help

Replace

For Each rngBoProbsOpps In ws.Range("BoProbsOpps")
Me.cmbProblemsOpps.AddItem rngBoProbsOpps.Value
Next rngBoProbsOpps

with

Me.cmbProblemsOpps.RowSource = "BoProbsOpps"