Automatic drop down list.

[Prasenjit Basumatary]

Hi,
I would like to know whether it is possible to create automatic drop down list. For example: it is like when we enter a function by entering "=" and typing a few letters of a function name, a drop down list of functions appear and we can select the particular function from the list by pressing TAB. To some extent it is like Data Validation however in case of Data Validation, we have to scroll the list and then select. I want to create the lists in one worksheet and automatic drop down list in another worksheet.

Thanks & regards,
Prasenjit

 

[bobhc]

Good day Prasenjit

If you go to file>options, advanced and scroll down to General and then click on the Edit custom list button you can create your own lists that will auto populate.


.

 

[Prasenjit Basumatary]

Good day Prasenjit

If you go to file>options, advanced and scroll down to General and then click on the Edit custom list button you can create your own lists that will auto populate.


.

Hi Bobhc
I am using MS Office 2007, so it will be easy for me if you guide me according to MS Office 2007.
Thanks & regards,
Prasenjit

 

[Debraj]

Hi Prasenjit

Can you please check the below thread..

I think, you are looking for this..

Search combo like Google

For more detail.. check this one..
http://forum.chandoo.org/threads/dropdown-based-on-search-string.15410/#post-96096

 

[Prasenjit Basumatary]

Hi Prasenjit

Can you please check the below thread..

I think, you are looking for this..

Search combo like Google

For more detail.. check this one..
http://forum.chandoo.org/threads/dropdown-based-on-search-string.15410/#post-96096

Hi Debraj

Actually I do not want the combo box. The auto populate list should come in the cells where I want to enter the selected customers' name from a list of more than 2000 customers' name. I have attached a sample workbook with yellow coloured cells where I want the auto populate.

Thanks & regards,
Prasenjit

 

[bobhc]

Prasenjit

The method I described should also be ok in 2007

 

[Prasenjit Basumatary]

Prasenjit

The method I described should also be ok in 2007

Bobhc

Thanks for your reply. Could you please guide me step by step process in 2007 ?

Thanks & regards,
Prasenjit

 

[bobhc]

Prasenjit, we have a saying "if it ain't broke, don't fix it" so this link will show how to make your list in 2007


http://www.internet4classrooms.com/excel_custom_list_07.htm


.

 

[Prasenjit Basumatary]

Prasenjit, we have a saying "if it ain't broke, don't fix it" so this link will show how to make your list in 2007


http://www.internet4classrooms.com/excel_custom_list_07.htm

.

Bobhc

I am sorry to say that this is not the solution which I am searching for. This is the custom list which shows in sequence. My requirement is: Select customers' name from auto drop down list just like when we enter function in a cell by entering "=" and typing a few letters of a function, a drop down list of functions appears and we can select the particular function by pressing "TAB" key. A sample workbook have been attached with yellow colored cells where I want the auto drop down list to appear.

Thanks & regards,
Prasenjit

 

[Prasenjit Basumatary]

Hi Prasenjit

Can you please check the below thread..

I think, you are looking for this..

Search combo like Google

For more detail.. check this one..
http://forum.chandoo.org/threads/dropdown-based-on-search-string.15410/#post-96096

Hi Debraj,

Here I brought a link with VBA code, please check http://www.contextures.com/xlDataVal11.html
Would you please include the feature of your workbook "Search combo like Google" with the above mention link.
It will be very helpful for me.

With thanks & regards,
Prasenjit