combo box control source
 

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

combo box control source
 

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

combo box control source
 

ComboBox1.RowSource = "MyRangeName"

or if named range is sheet specific

ComboBox1.RowSource = "Sheet1!MyRangeName"



--

Regards,
Nigel




"paula" wrote in message
...
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

combo box control source
 

Oops! sorry misread row for control - but maybe that is what you want?

--

Regards,
Nigel




"Nigel" wrote in message
...
ComboBox1.RowSource = "MyRangeName"

or if named range is sheet specific

ComboBox1.RowSource = "Sheet1!MyRangeName"



--

Regards,
Nigel




"paula" wrote in message
...
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