Scroll / Search
 

I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!

Scroll / Search
 

What kind of list, validation then you can't use match letter entry, you
need to use a combo box from the control toolbox

What do you mean by scrolling through the drop down list, using the mouse
wheel?

--
Regards,

Peo Sjoblom


"April "I'm not quite sure..."" <April "I'm not quite
wrote in message
...
I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!

Scroll / Search
 

April

This works with a data validation drop down.
In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown just enter the first letter and the click the dropdown arrow and you
are at the beginning of that part of your list.

Does that help?

Mike Rogers



"April "I'm not quite sure..."" wrote:

I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!

Scroll / Search
 

Hi April

There's a sample file on how to achieve this available for download at
Debra Dalgleish's site.
http://www.contextures.com/DataValHeadings.zip
--
Regards

Roger Govier


"April "I'm not quite sure..."" <April "I'm not quite
wrote in message
...
I created a drop down list and I'm not sure how to enable scrolling
through
the drop down or first letter search - help!!

Scroll / Search
 

Hi,

Hi,

Follow this URL " Excel -- Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

Challa Prabhu


"April "I'm not quite sure..."" wrote:

I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!

Scroll / Search
 

Hi

Copy all the columns to a different location in the Excel sheet. This
is basically to run an advance query which will fetch all the records in the
excel sheet even if you have misspled while typing.

Assuming that you have copied all the columns to a single spread sheet, you
know the column heading now, save the excel sheet.

Now I wiil be using the Advance filtering techniques so that all the column
information are retrieved even if the typed cells are misspelled, which
normally is not the case when you do a simple filtering technique. The
filtered values may not be correct.

To retieve the values;

1. Select all records and the column headings and define a name for the
range List. This is the List range name.
2. Select all column headings and paste in a seperate row anywhere in the
spreadsheet.
2. Select the pasted column heading along with an three empty row and define
a
name. This is the criteria range name.

Note: You can specify more criteira in addition rows.

3. Define a criteria on the second row for all columns, if necessary. For
example S* will display all details specific to "S'.
4. Click Data- Filter- Advanced Filter
5. Type the List name
6. Type the Criteria Name
7. Click copy to another location option - Mandatory
8. Click Copy to
9. Click the cell below the criteria range

All data will be displayed specific to the query you requested. This is very
usefull if the spreadsheet data are mistyped or mis-spelled. Now you have
done a database funtion on your excle spread sheet.

Challa Prabhu


"April "I'm not quite sure..."" wrote:

I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!

Scroll / Search
 

Yes, thank you!

"Mike Rogers" wrote:

April

This works with a data validation drop down.
In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown just enter the first letter and the click the dropdown arrow and you
are at the beginning of that part of your list.

Does that help?

Mike Rogers



"April "I'm not quite sure..."" wrote:

I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!

Scroll / Search
 

I figured out how to pseudo match entry! By "scrolling" I do mean with the
mouse wheel - otherwise I have to use the scroll bar. I know it sounds lazy,
but it's a long list!!

thanks!

April

"Peo Sjoblom" wrote:

What kind of list, validation then you can't use match letter entry, you
need to use a combo box from the control toolbox

What do you mean by scrolling through the drop down list, using the mouse
wheel?

--
Regards,

Peo Sjoblom


"April "I'm not quite sure..."" <April "I'm not quite
wrote in message
...
I created a drop down list and I'm not sure how to enable scrolling through
the drop down or first letter search - help!!