Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding items to a combo box on a user form Gazz_85[_2_] Excel Discussion (Misc queries) 1 July 9th 09 05:00 PM
Add items to a combo box and make them available after closing the sheet [email protected] Excel Discussion (Misc queries) 1 June 25th 07 09:42 PM
View List Items in Combo Box rl Excel Worksheet Functions 6 May 17th 07 12:53 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Different colors for combo items Malcolm Excel Programming 1 November 6th 03 12:26 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"