Add 2 items into dictionary

Hi Guys,

i want to add 3 items into dictionary:

Table name as key , table address and array of headers from table as items

Somehing like

dic.add "t_test", "[Sheet1$A1:C4]", ArrayNames

where ArrayNames = "Lp, First Name, Last Name"

What is the best solution here?
Create class for this ?

I am not good with classes but maybe this is time to implement them...

Best,
Jacek

Like this?

Please Login or Register  to view this content.

Hi jindon,

thank you but when i will be splitting ArrayNames it should be done separately from "[Sheet1$A1:C4]".

Best,
Jacek

When you retrieve the item

Please Login or Register  to view this content.

Please Login or Register  to view this content.

jindon,

thank you very much.

This is working.
The second metohs is great.

If i have arraynames like here:

Screenshot_7.png

I can modyfy first code to:

Please Login or Register  to view this content.

But second code is not working.

How can i resize arraynames using second dimension in my case?

How to get

UBound(dic("t_test")(1))

from 2cd dimension?

Best,
Jacek

ok this is working !

UBound(dic("t_test")(1), 2)

so classes are not useful here?

Best,
Jacek

That's because you said

where ArrayNames = "Lp, First Name, Last Name"

So I thought it was a 0 based 1D array.
It should be

Please Login or Register  to view this content.

thank you.

joindon you are using classes sometimes ?
Or classes are rarely useful?

Best,
Jacek

Only sometime like put common Event together for Controls on a user form.

jindon,

thank you

can you show some example? I am very courious and love your code

Best,
Jacek