declare public dictionary on workbook open

[jaryszek]

Hi,

i want to add list to dictionary and use it in worksheet change event later when worksheets are changed.

Something like :

Please Login or Register  to view this content.

how to do this?

Best,
Jacek

[jindon]

Do you mean?
1) To a standard module

Please Login or Register  to view this content.

2) ThisWorkbook modue

Please Login or Register  to view this content.

[jaryszek]

Great,

thank you !
working like a charm!

Best,
Jacek

[jaryszek]

Hi,

i want to refresh the topic:

On workbooks Open i am setting Dictionary.

On Module i have:

Please Login or Register  to view this content.

but i can not use this dictionary.
Why?

Best,
Jacek

[jindon]

You need to set the reference to the objects first... e.g.

Please Login or Register  to view this content.

[rorya]

You can't assign all the items to a simple String variable. Use:

Please Login or Register  to view this content.