Option Explicit
Private Sub UserForm_Initialize()
With Me.ComboBox1
.ControlSource = ActiveWorkbook.Worksheets("sheet9999") _
.Range("somenamedrangehere").Address(external:=Tru e)
End With
End Sub

Adjust the sheetname and range name to what you need.

paula wrote:

I need to use a named range for the control source for a combo box in a
userform. is that possible, and if so, how!

thanks!
--
paulao

--

Dave Peterson