how do i activate the custom dictionary in word

For item Dog, Cat and Rat, the values stored are 11, 12, and 13 respectively. Here Count is 3 because we have chosen 3 different words to be added into our dictionary. In that we will be able to see the Count of variables added into our dictionary, item numbers and assigned key value to them and what type of variable they are as shown below. Then click on the plus sign in Watch window to explore the things stored in each Key numbers. There will be a point where we will see Watch window got updated with the item and key number assigned to each number. Step 16: To see the update in Watch window, press F8 key to run each step one by one. We will see our first word “ Dog” will get added into the dictionary and will be visible in an Immediate window as shown below. Step 15: Now run the code by clicking on the Play button or by pressing the F5 key. In the watch window, we will get our Watch list which is named as Dictionary as shown below. Step 14: In the watch window, name the expression and select the Module in which you have written the code. For this Right-click on it and click on Add Watch as shown below. Step 13: Now add the Watch list in Watch window.

We adjust the opened Immediate and Watch window anywhere in a screen as per our need. Step 12: Go to View menu and select Watch Window and Immediate Window as shown in the below list.Īfter that our VBA window will probably look like as shown below. Now to understand how words will be added into Excel VBA Dictionary, we need to add some more watch windows. Step 11: Now insert Debug.Print command to print the values stored in used keys as per numbers fed. Let’s say those words be “ Cat” and “ Rat” with Key 12 and 13 respectively.

Step 10: Similarly, we add a few more words. Step 9: Now we will assign an Item to that Key. Here we have randomly taken the key as 11. Add which is used for adding the words in the dictionary with any Key as shown below. Step 8: As we already discussed the different properties or applications which we can choose in Excel VBA Dictionary. Step 7: Now we will open the With-End with Loop as shown below. Step 6: Now set that variable Dictionary as New Dictionary as shown below. To avoid confusion, you can choose any other name as per your choice. Step 5: Now we will define a variable as Dictionary and assign it the function Dictionary as shown below. Step 4: Now write the subprocedure for VBA Dictionary in any name as shown below. So open a Module from Insert menu option as shown below.

Step 3: Now we need a module to write the code for VBA dictionary.

How do i activate the custom dictionary in word