Excel combobox problem
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 ------------------------------------------------------------------------ aoeui's Profile: http://www.excelforum.com/member.php...o&userid=26603 View this thread: http://www.excelforum.com/showthread...hreadid=398764 |
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 |
Maybe...
Option Explicit Private Sub ComboBox1_GotFocus() Me.ComboBox1.ListFillRange _ = Worksheets("sheet1").Range("a1:a10").Address(exter nal:=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 |
All times are GMT +1. The time now is 04:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com