Excel combobox problem

[aoeui]

I'm using a combobox populated from rTest (a 4 column, 60 row named
range) and linking it to a cell named Test. My problem is that it only
displays the first 41 rows of that range in the dropdown.

The following are the properties that I've changed for the combobox:

LinkedCell = Test
ListFillRange = rTest
ListRows = 20
SelectionMargin = false
BorderStyle = fmBorderStyleSingle


This is excel 2003.

 

[aoeui]

revised problem:

A combobox apparently does not update itself when changes are made to
its named range. Adding several entries or moving the range results in
the combobox having the wrong values until you close and reopen the
workbook.

My question is, how can I force a refresh of a combobox every time its
source range is changed? VBA is acceptable.

 

[Dave Peterson]

Maybe...

Option Explicit
Private Sub ComboBox1_GotFocus()
Me.ComboBox1.ListFillRange _
= Worksheets("sheet1").Range("a1:a10").Address(external:=True)
End Sub

Although, in my minor testing, if I changed something in the listfillrange, it
showed up in the combobox.