combobox question
 

is it possible to set the list fill range using a range name? or even just a
range?

this doesn't seem to work either,
Me.ComboBox1.ListFillRange = Worksheets("db").Range("b3:ad15")

i wanted to use something like this:
Me.ComboBox1.ListFillRange = rngLU
--


Gary

combobox question
 

Try passing a string.

Me.ComboBox1.ListFillRange _
= Worksheets("db").Range("b3:ad15").address(external :=true)

Or maybe to save some typing:

Dim myRng As Range

With Worksheets("DB")
Set myRng = .Range("b3:ad15")
End With

With Me.ComboBox1
.ColumnCount = myRng.Columns.Count
.ListFillRange = myRng.Address(external:=True)
End With



Gary Keramidas wrote:

is it possible to set the list fill range using a range name? or even just a
range?

this doesn't seem to work either,
Me.ComboBox1.ListFillRange = Worksheets("db").Range("b3:ad15")

i wanted to use something like this:
Me.ComboBox1.ListFillRange = rngLU
--

Gary

--

Dave Peterson

combobox question
 

used the first example for now, may try the 2nd if the range is going to expand.
thanks dave

--


Gary


"Dave Peterson" wrote in message
...
Try passing a string.

Me.ComboBox1.ListFillRange _
= Worksheets("db").Range("b3:ad15").address(external :=true)

Or maybe to save some typing:

Dim myRng As Range

With Worksheets("DB")
Set myRng = .Range("b3:ad15")
End With

With Me.ComboBox1
.ColumnCount = myRng.Columns.Count
.ListFillRange = myRng.Address(external:=True)
End With



Gary Keramidas wrote:

is it possible to set the list fill range using a range name? or even just a
range?

this doesn't seem to work either,
Me.ComboBox1.ListFillRange = Worksheets("db").Range("b3:ad15")

i wanted to use something like this:
Me.ComboBox1.ListFillRange = rngLU
--

Gary

--

Dave Peterson