Storing values in dynamic array

[Un-Do Re-Do]

This is a holistic type question.
If I had a dynamic array of string variables, can these be stored within Visual Basic Editor? Rather than a hidden worksheet or text file.

[Fluff13]

If the array needs to be dynamic, where would it get the values to begin with?

[CK76]

Not sure what you mean by dynamic... but you can store in VBE like.

Sub Demo()
Dim ar
ar = Array("Something", "SomethingElse", "Cheese") 'Add more item as desired

'Alternately
Dim strAr
strAr = Split("Something,SomethingElse,Cheese", ",") 'Add more item to string as needed
End Sub

[Un-Do Re-Do]

If the array needs to be dynamic, where would it get the values to begin with?

It's hard to explain as I don't know how to do it yet, but it will be a list of words which are passed through a spell checker and if passed, the spell check will not query it next time. The words are stored in a dynamic array.
For example, if I check strings such as "e = mc^2", initially it will be queried by a spell checker. If I then have an event which approves the sting, it will not be queried the next time a spell check is run.

[Un-Do Re-Do]

Not sure what you mean by dynamic... but you can store in VBE like.

I was looking to input via Excel, not writing to Visual Basic Editor.

[CK76]

It's technically possible. But since any variable/object is destroyed by garbage collector when it goes out of context...

It will depend on the scope of variable.

If you store in public variable. This can be accessed as long as workbook is open (once closed, it will be destroyed).

To have access to it across instance, you'd need to store it in somewhere else (Ex: worksheet, external file such as txt, registry etc)

Edit: To expand on technically possible part. You can write another module to update module where you want to store something. But this is convoluted process and there are several issues/dangers associated with this. Simply storing it in worksheet is much easier to control and maintain (or in external location).

[Fluff13]

Assuming that you are using a custom built checker of some sort, then you would have to store those strings somewhere.

[Un-Do Re-Do]

OK thanks to both. I will look at storing in a worksheet or text file.

[Fluff13]

Glad to help & thanks for the feedback