Breaking News: Grepper is joining You.com. Read the official announcement!

VBA Dictionary Data Type

Super Skimmer answered on April 19, 2022 Popularity 3/10 Helpfulness 2/10

answer VBA Dictionary Data Type

VBA Dictionary Data Type

Comment

Sub DictionaryBasicSetup()
    ' (1) set up the VBA dictionary object (Tools > References > Microsoft Scripting Runtime)
    ' (2) insert two random values in the dictionary
    ' (3) print the values to the immediate window be referencing the keys
    Dim dict As Scripting.Dictionary

    Set dict = New Scripting.Dictionary
    
    ' insert some random items
    dict("Alice") = "555-778-0131" 
    dict("Bob") = "555-202-0114"
    
    ' print items to the immediate window
    Debug.Print dict("Alice")
    Debug.Print dict("Bob")

End Sub

Popularity 3/10 Helpfulness 2/10 Language vb

Source: wellsr.com

Tags: dictionary vba

Link to this answer
Share Copy Link

Contributed on Apr 19 2022

Super Skimmer

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

VBA Dictionary Data Type

Contents

More Related Answers

VBA Dictionary Data Type

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.