Hello I currently have a drop down menu with a long list of values to choose from. (I set it up in the data then validity menu) I would like to be able to start typing in the drop down menu to filter through the values (Example: Start typing p so only values start with p appear, type pl and only values that begin with pl appear etc etc)
As of right now it is only possible to scroll throug hand click on one.
Any help would be appreciated thank you
Here is a suggested file.
pilly_ask_en.ods (25.8 KB)
When typing a keyword in the yellow cell, a list will open, choose with the arrows.
Validation was used, and a macro linked to the worksheet Event, Content changed.
Segue uma arquivo com sugestĂŁo.
Ao digitar uma palavra chave na celula amarela, será aberto uma lista, escolher com as setas.
Foi usado Validação, e macro ligada ao Evento de planilha, Conteudo alterado.
Thank you for your reply. I modified it to pull from list instead of cell range. I tried to copy/paste the yellow cell to create a long list of yellow cells so i can repeat the process over and over however only the first one still works (The Original yellow cell)
The macro is for a cell, for several is another macro …
See file with two options, Sheet1 cell, Sheet2 column
pilly_ask_94333_en.ods (25.9 KB)
A macro esta para uma célula, para varias é outra macro…
Veja arquivo com as duas opções, Planilha1 célula, Planilha2 column
Im still not really finding what I am looking for. I found an exact example of what im trying to accomplish but it is in excel.
You can request an enhancement, see How to Report Bugs in LibreOffice - The Document Foundation Wiki
If you do, report the bug number back here so other can find it. Precede the number with tdf# to make the link, e.g. tdf#123456 (I have prevented this one from creating a link)
There are a lot of similarities between that Excel demo and @schiavinatto macro. Maybe you are not pressing Enter after the first letters?
To avoid AutoCorrect changing your initial letters to a word in the yellow cells, you might want to define a new Style for those cells with a language of None. On one of my tests sa was changed to as on pressing Enter, simply changing the cell style to Text and modifying it under Font to language None fixed it.