Fill in text from drop down list box in Excel

B

Bexi

Hello,

I have created a drop down list box but the list is getting too big and
the user has to scroll down the list to select the data. Is there a
feature I can use to display the data that start with the same string.
For example: If I type "Be" in my box, the box could display the list
that start with "BE or Be".

I created the drop down list by using "Data", chose "Validation", and
chose "List" from the "Allow" tab.

Thanks for your help.

Bexi
 
G

Gord Dibben

Bexi

If your drop-down list if from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


Hello,

I have created a drop down list box but the list is getting too big and
the user has to scroll down the list to select the data. Is there a
feature I can use to display the data that start with the same string.
For example: If I type "Be" in my box, the box could display the list
that start with "BE or Be".

I created the drop down list by using "Data", chose "Validation", and
chose "List" from the "Allow" tab.

Thanks for your help.

Bexi
Click to expand...

Gord Dibben MS Excel MVP
 
L

L. Howard Kittle

Hi Bexi,

As Gord says, no auto-complete with Data > Validation. However, this may do
what you want if you are able to sort your list.

Sort the list and then at the beginning of the A's enter a single A. Do the
same for all the other letters on down the list, B, C etc.

Now when you want to select something from the list, type the letter in the
validation cell and DO NOT hit enter, the cell will still be in the edit
mode with the cursor blinking. Click the drop down arrow and you will be at
that letters list.

You really can hit enter when you type in the letter but you will have to
reselect the cell which is another step.

HTH
Regards,
Howard
 
B

Bexi

I tried it and it worked. THANK YOU.

But, I wanted to be able to just click the "Enter" key instead
of using the mouse every time I selected an item from the list.

Can I still add a VBA code that allows the user to use the "Enter" key
instead of using
the mouse? Do you have that code? I am an accoountant with a little
knowledge of programming.

Thank you once again.
 
Top