Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Losing List Items
I'm using a combo box from the control toolbox for a list of items. As
use the list, the top item in the list seems to disappear. I have no idea why, the cells that the list comes from doesn't chang and if you view the properties of the combo box, it still reference all the cells that the combo box comes from. Any idea of why this occuring and how to stop it -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Losing List Items
Are you sure that the item or items have really disappeared? If you have a
long list, or the list is set to a whole column in the spreadsheet, the combobox will have a scrollbar, and the item you just selected is automatically set to appear at the top, meaning that you have to scroll up to see the previous items. Again, with a long list, it might appear that the scroll bar is already at the top, even if it is not quite. See whether you can scroll up. "InnerChild " wrote in message ... I'm using a combo box from the control toolbox for a list of items. As I use the list, the top item in the list seems to disappear. I have no idea why, the cells that the list comes from doesn't change and if you view the properties of the combo box, it still references all the cells that the combo box comes from. Any idea of why this occuring and how to stop it? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding items to a combo box on a user form | Excel Discussion (Misc queries) | |||
Add items to a combo box and make them available after closing the sheet | Excel Discussion (Misc queries) | |||
View List Items in Combo Box | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Different colors for combo items | Excel Programming |