dropdown lists in VBA

[jewel]

hi all

not too sure how to approach but here goes
we have a compiled exe file - made up of numerous files.
this generates a form with drop down boxes using parameter files in csv format - at the moment only allowing the first letter to be effective - how do I change the code to allow the next letter to be effective - eg if choosing a..... this brings up all locations starting with a........ but if I want ad........ how do I do this - because if you type in d after the a - you now get all the locations starting with d - if you think you can help happy to clarify as I may not have explained properly. cheers

 

[BrainB]

Are you in the right forum ?
This one deals with Visual Basic for Applications - ie. within the Microsoft Office family of applications. Very rarely involved with .exe files.

The Dropdown box in Excel (Controls toolbox) behaves similar to your requirements by default. Apart from normal dropdown behaviour, if letters are typed it displays the first key (in list order) which contains them in the order typed.





Regards
BrianB
** Let us know if you get something that works !
================================