Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anybody else confirm a "bug" regarding comboboxes on a
worksheet? Add a combobox to a sheet and set its ListFillRange to a named range. Resize the named range. View the items in the list. Repeat a couple of times. The combobox does not show all items in the newly-resized range name. I found a workaround: First set the ListFillRange = "" and then to the newly-resized range name. However, this is not needed for a combobox on a userform. Just for a worksheet. I didn't see anything on the KB. Anybody else seen this problem? I'm using XL2000 SR1 and SR3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Resizing an activex checkbox control | Excel Worksheet Functions | |||
ActiveX combobox | Excel Worksheet Functions | |||
ActiveX Combobox and LinkedCell | Excel Worksheet Functions | |||
formatting the list items for ComboBox created using Forms | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |