Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dropdown lists in VBA

Status
Not open for further replies.

jewel

Technical User
May 23, 2001
158
NZ
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
 
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 !
================================
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top