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.


aoeui wrote:
>
> 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.
>
> --
> aoeui
> ------------------------------------------------------------------------
> aoeui's Profile: http://www.excelforum.com/member.php...o&userid=26603
> View this thread: http://www.excelforum.com/showthread...hreadid=398764

--

Dave Peterson