Drop Down List

J

Jimish

is it possible in excel as it is html.
that in a drop down list created of say 100 to 150 items if i press say
m it shows items starting with m rather than scrolling down.
 
R

Rowan

Assuming you want this combobox on a worksheet.
Click View>Toolbars>Control Toolbox.
On the control Toolbox click on the combobox and then click and drag on
you sheet to place the combobox.
Right click the combobox and select Properties.
Make sure tha AutoWordSelect is set to True.
Set ListFillRange to be the range that has the list of items you want ot
appear in the combobox eg A2:A28.
Set LinkedCell as the cell you want to hold item selected in the combobox.
Close the Properties window.
On the Control Toolbox click Exit Design Mode (top left button).
Close Control Toolbox.

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
Excel Excel: How do I put a formula in a drop down list 11
Data Validation List (conditional) 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Drop down list 3
Populate list or combo box from closed workbook 4
Print Macro with two drop-down lists 4
Colour-coding a cell from a drop down list 1

Top