Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Excel 2003 restricting functionality | Excel Discussion (Misc queries) | |||
creating a combobox dynamically on an excel sheet | New Users to Excel | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
Excel problem with web based spreadsheets | Excel Discussion (Misc queries) | |||
Staring Excel Problem | Excel Discussion (Misc queries) |