Hi everyone,
First of all im sorry if such a thread exists...but when i searched i didnt find any
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:
http://i638.photobucket.com/albums/u...rklide00/1.jpg
The no of periods can vary from 3-10 periods ( or more at times)
So far im working with user forms where the end user just enters data and the data is transfered to excel where it is processed. My problem is that i want the user use only the users forms to get the data
What i need is a way to have a user form take 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(check the above data to have an idea of what im talking about)
OR
Ive found a code on the net where i can display the data as follows
http://i638.photobucket.com/albums/u...rklide00/2.jpg
But it has 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
If anyone could help me to display the data it would be great
Thx in advance