Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

How to set the amount of values visible when open a combo box?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AA Arens - 02 Sep 2006 08:05 GMT
How to set the amount of values visible when open a combo box?
and
How to have a default value highlighted when opened as always the top
of the list is visible.

Bart
Excell 2003
jkend69315@aol.com - 02 Sep 2006 17:53 GMT
Is your combobox in a userform or on a worksheet?

> How to set the amount of values visible when open a combo box?
> and
[quoted text clipped - 3 lines]
> Bart
> Excell 2003
AA Arens - 03 Sep 2006 08:25 GMT
On a worksheet. With data from another sheet. The combo is set via Menu
> Data > Validation > List.

Bart

> Is your combobox in a userform or on a worksheet?
>
[quoted text clipped - 5 lines]
> > Bart
> > Excell 2003
Debra Dalgleish - 03 Sep 2006 15:02 GMT
The data validation dropdown is limited to 8 rows, and can't be changed.

If you can use macros, there's a sample file here that provides a
combo box from which you can select one of the values. In a combo box, you
can set the number of rows in the dropdown list. There are instructions
here:

  http://www.contextures.com/xlDataVal11.html

The data validation list will open with the cell's entry selected in the
dropdown list, so you could type the default value in the cell. Then,
users can select a different item if necessary.

> On a worksheet. With data from another sheet. The combo is set via Menu
>
[quoted text clipped - 11 lines]
>>>Bart
>>>Excell 2003

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.