VBA Dictionairy Object - Retain Values?

[Jameo]

Just a quick question all.

Is it possible to retain Dictionairy Items after runtime? Or do all dictionairys clear after excecution of the code?

Cheers

 

[xenou]

You can place your dictionary in a static variable or private module variable:

Sub Foo()
Static d As Dictionary
    If d  Is Nothing Then
        Set d = New Dictionary
    End If
End Sub

Private d As Dictionary
Sub Bar()
    If d  Is Nothing Then
        Set d = New Dictionary
    End If
    '//Code 
End Sub

Such variable are lost for a variety of reason - notably, if your vba program crashes or if you hit the reset button, so they aren't 100% reliable for mission critical purposes. If you need to save data between excel sessions its another story - you have to devise some kind of persistent storage strategy (often in Excel this just means writing values to a hidden sheet or something along those lines).

 

[Jameo]

xenou,

Thanks. All data necessary that requires persistant storage is written to a sheet. This is just for excecution of a series of modules during one session.

Cheers for your help