Hi, I stumbled across the subject set up for searching text strings in a list of items (see below). I'm still new to VBA and macros. Most of the time I can figure out what's going on with them and make them work to my application. However, I really would like to see the one I found on the web below, but I guess I'm not savvy enough to put everything together in a spreadsheet and make it work. If there is anyone on this list that knows how to make this work and could either explain to me how to make it work or provide me with a sample Excel file with this in it that I can examine and apply it to an application I have in mind for work I would really really appreciate it? Please advise.
http://www.dicks-blog.com/archives/2005/02/16/limit-a-listbox/ Regards, Steve --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---