List

A

Alicia

I have created a drop-down list for my spreadsheet, please advise on how do i
format the list in a way that when i hit the "D" it will jump to the entries
that are starting with "D"

This would be helpful when I have a extremely long list. Thanks
 
A

Alicia

Frank,
Is there any other way that you could reccomend other than using Data -
validation, as i have a preset list of project code, and I will have to use
that preset list as a reference to enter the project that has been work on,
 
F

Frank Kabel

Hi
then you have to use VBA and a combobox tool element for this. But this
would be much more work
 
D

Dave Peterson

If you show the Control toolbox toolbar (view|toolbars), you can add a combobox
to your worksheet.

There's another icon on that toolbar (design mode is the tooltip when the cursor
lingers over it).

Click on that and then rightclick on the combobox.
Select properties
assign the linkedcell to the cell beneath the combobox (so your formulas won't
have to change)
Assign the ListFillRange to the same list as you used for Data|validation
(you'll have to type it in)
Assign Style to 2-fmstyledropdownlist
(0-fmStyleDropDownCombo will allow the user to type things not on your list)
assign MatchEnter to either 1 - fmMatchEntryComplete
(or 0 - fmMatchEntryFirstLetter)
(try it both ways and see what you want--I'm guessing complete)

And then toggle the designmode icon to test it out.

If you format the linked cell with a custom format of ;;;, it may be nicer.
 
Top