View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Thorpe Mark Thorpe is offline
external usenet poster
 
Posts: 11
Default 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/