Displaying data from spreadsheet in Userform

darklide · #1 03-12-2010, 05:42 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
flash shockwave object not displaying	webguync	PowerPoint	7	04-20-2010 07:23 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data.	psmaster@earthlink.net	Excel	0	11-24-2009 11:54 AM
[Word 2003] Macro's and a UserForm	xanuex	Word VBA	0	10-19-2009 05:42 AM
help to convert swf to avi for displaying in ppt?	Frederick	PowerPoint	1	09-13-2009 08:10 PM
MS Office 2007 Not Displaying Properly	MSOfficer	Office	1	02-12-2009 09:11 AM