Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2010, 05:42 AM
darklide darklide is offline Displaying data from spreadsheet in Userform Windows XP Displaying data from spreadsheet in Userform Office 2007
Novice
Displaying data from spreadsheet in Userform
 
Join Date: Mar 2010
Posts: 1
darklide is on a distinguished road
Default Displaying data from spreadsheet in Userform

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


Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying data from spreadsheet in Userform 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
Displaying data from spreadsheet in Userform help to convert swf to avi for displaying in ppt? Frederick PowerPoint 1 09-13-2009 08:10 PM
Displaying data from spreadsheet in Userform MS Office 2007 Not Displaying Properly MSOfficer Office 1 02-12-2009 09:11 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft