VBA example - Excel 2007: VBA dictionary

VBA dictionary

In this example, We use VBA built-in function Ucase() to help us create a simple dictionary.  By using this function, we can search for a term in the list box without caring about case-sensitivity.

Besides using the VBA built-in function, this example also aims to provide you some techniques used in writing items to the list box, reading an item from it, and selecting the list item by VBA code.

To run this example VBA code, you will need a Form, a TextBox, and Two ListBox. You may type the terms and their translation text in to your current worksheet.


Pradeep comment




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.