Transfer Dictionary records into a Worksheet

[hagea_dan]

Hi,

I need to paste the records of a dictionary that has 3 items into a worksheet but I can't come up with any algorithm because I just started using dictionaries and classes.
Can you please give me an example of how to do this?

The data from my dictionary looks something like this:

[TABLE="class: grid, width: 400, align: left"]
<tbody>[TR]
[TD]KEY 1[/TD]
[TD]ITEM(STRING)[/TD]
[TD]ITEM(STRING)[/TD]
[TD]ITEM(DOUBLE)[/TD]
[/TR]
[TR]
[TD]KEY 2[/TD]
[TD]ITEM(STRING)[/TD]
[TD]ITEM(STRING)[/TD]
[TD]ITEM(DOUBLE)[/TD]
[/TR]
[TR]
[TD]KEY 3[/TD]
[TD]ITEM(STRING)[/TD]
[TD]ITEM(STRING)[/TD]
[TD]ITEM(DOUBLE)[/TD]
[/TR]
</tbody>[/TABLE]

 

[hiker95]

hagea_dan,

We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


And, in order to further assist you it would help us if you posted all of your macro code using code tags.

When posting VBA code, please use Code Tags - like this:

[code=rich]

'Paste your code here.

[/code]

 

[hagea_dan]

Hi hiker95,

You are right, I should have posted my code for the readers to better understand my request but I just wanted to see a general example not a 100% accurate solution.
Anyway I managed to come up with a solution to this problem on my own.
I've transfered the dictionary items into a 2D array and then gave my desired range the array value.

Kind Regards.

 

[hiker95]

Hi hiker95,

You are right, I should have posted my code for the readers to better understand my request but I just wanted to see a general example not a 100% accurate solution.
Anyway I managed to come up with a solution to this problem on my own.
I've transfered the dictionary items into a 2D array and then gave my desired range the array value.

Kind Regards.

hagea_dan,

I am glad that you were able to solve your own request.

And, come back anytime.