Displaying Binomial trees in excel

**darklide** · 03-10-2010, 09:33 AM

Hi all,
First of all im sorry if such a thread exists...

What i wanted to know if anyone knows a way to display data in excel(using VBA), where the data is in a binary tree form, as follows:

\1

The no of periods can vary from 3-10 periods ( or more at times)

What i want is to either have a way to display it as follows:

\1

But as be able to have trees of different size plus be able to include some info such as the no of periods(at the bottom of each column) and be able to add the initial data from which the data was created. (the code i used above to create a tree like that has two problems: 1. i cant put any labels such as the no of periods and such 2. i need a button to return back to the userform from which the data was taken)

OR
if the above is not possible, i need a way to have a user form the data as it is in the worksheet. Ive thought of textboxes but then i'll have LOTS of them to put since i have about 10 worksheet with different trees of different size

Thx in advance for answering

**darklide** · 03-13-2010, 08:47 AM

No one can help me? :S (sorry for double post)

Im kinda desperate now.

Ive nearly completed my project, all i need is a way to display the data from arrays(or binomial trees in my case) in a userform.

Could anyone tell me a simple way to do that? Having part of an excel sheet displayed in the userform....Not just listbox please, ive tried but the effects are not that good

**Andy Pope** · 03-13-2010, 09:17 AM

One way would be to copy the range of cells as an image and display the image.

**darklide** · 03-13-2010, 10:35 AM

thx but how can i do that? :S

Should i paste it in a label? or something like that?

**Andy Pope** · 03-13-2010, 11:36 AM

Assuming the tree changes between usage you would want to do it via code rather than copy/paste.

The example has code for copying a shape from the sheet to an image control.
http://www.andypope.info/vba/userformdraw.htm