This type ahead functionality is not available in excel. I tried to this about 2 years back and was stuck in the same situation as you are. The only workaround is to have a search cell with a macro that can change the drop downs for another cell. The superset of values can be placed in a hidden column or column in a hidden sheet. But this will also be cumbersome to the users.
Sent from my iPhone > On Apr 25, 2015, at 7:00 AM, Pratik Thaker > <[email protected]> wrote: > > Hi Mark, > > User will select the value from list only. It's just that user should be able > to type in the cell and the list should be narrowed down as per user's input > (like usual comboboxes of web UI) > > Right now user has to select the value by scrolling through whole list. > > Regards, > Pratik Thaker > > -----Original Message----- > From: Mark Beardsley [mailto:[email protected]] > Sent: Saturday, April 25, 2015 4:18 PM > To: [email protected] > Subject: RE: Typable dropdown in excel file (XLSX) > > Can I make sure that I am clear what you want? > > Are you asking whether it is possible to create a drop down list that will > change dynamically as the user enters something into a cell? If so, then I do > not believe that this is possible; according to Microsoft, a data validation > can only be used for the following - > > / * Make a list of the entries that restricts the values allowed in a > cell. > * Create a prompt message explaining the kind of data allowed in a cell. > * Create messages that appear when incorrect data has been entered. > * Check for incorrect entries by using the Auditing toolbar. > * Set a range of numeric values that can be entered in a cell. > * Determine if an entry is valid based on calculation in another cell. > / > (https://support.microsoft.com/en-us/kb/211485) > > If you do know of a way this can be accomplished using Excel directly, can I > ask you to post the instructions here please? That way, someone can have a go > at re-creating these steps with POI and help you that way. > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Typable-dropdown-in-excel-file-XLSX-tp5718511p5718583.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] For additional > commands, e-mail: [email protected] > > ________________________________ > The information in this email is confidential and may be legally privileged. > It is intended solely for the addressee. Access to this email by anyone else > is unauthorised. If you are not the intended recipient, any disclosure, > copying, distribution or any action taken or omitted to be taken in reliance > on it, is prohibited and may be unlawful. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
