user form help

sujithy007

New member
Joined
Apr 2, 2013
Messages
15
Reaction score
0
Points
0
Hi
can any one help me to get the data in groups in user form,
like i have group1- in that we are having subgroups, like gp1-subgrp1, gp1-subgrp2, .. like this.
when we click on group1, the subgroups should appear and when we click again subgroups should hide..
like we can have grop2 and group3 , .. so on..

i can acheive by this treeview concept, but i need in any other way.. so pls help me in this..
thank you
 

Charles

New member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
0
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hi,

Can you attach a copy so we can see what you are trying to do?
 

sujithy007

New member
Joined
Apr 2, 2013
Messages
15
Reaction score
0
Points
0
u can find in attached sheet, and please let me know if have any ideas, in doing other way
Hi,

Can you attach a copy so we can see what you are trying to do?
 

Attachments

  • form_lib.xlsm
    121.7 KB · Views: 41

Charles

New member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
0
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hi,

Are you wanting to show the list of "Teams" and then click on the Team you wish to see the "Team members"?
 

Charles

New member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
0
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Ok,

When the "Team Members" are listed what do you want to happen?

Added: The actual concept of "TreeView" I'm not familiar with.
 

sujithy007

New member
Joined
Apr 2, 2013
Messages
15
Reaction score
0
Points
0
when we click on team, the team members should appear, and when we click again on the same team, the listed team members should hide.... this is concept.. u can see this functionality on yahoo messanger.. in that u have groups, like wise i need the same
 

Charles

New member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
0
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hi,

When you open the file and select "Team" you will see the Teams.
You can double click the Team and the "Tree View" will show. You can the double click on the same team and the TreeView" will collapse.
Not sure what you want to do after this.
 

Attachments

  • form_lib1.xlsm
    125.8 KB · Views: 58

sujithy007

New member
Joined
Apr 2, 2013
Messages
15
Reaction score
0
Points
0
hi
thanks for replay
i need this, with out mscomctl library..
Hi,

When you open the file and select "Team" you will see the Teams.
You can double click the Team and the "Tree View" will show. You can the double click on the same team and the TreeView" will collapse.
Not sure what you want to do after this.
 

Charles

New member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
0
Location
Biloxi
Excel Version(s)
Mac Excel 2011
HI,

I'm not sure what you mean by:

i need this, with out mscomctl library..

What is it your trying to do?
The form shows the "TreeView".
Are you receiving an error?
What do you want to accomplish when the form is displayed.
There is a thread in the forum that may help you more than I.
It's

""excelguru.ca/content.php?194""

Remove the quotes to see the site.
Add the url.
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
@Charles: What sujithy007 means is that on some machines when you run your procedure you get a "Compile error: Can't find project or Library, and this is highlighted in the VBE:
Private Sub TreeView1_NodeClick(ByVal Node As MSComctlLib.Node

@sujithy007: Couple of thoughts:
1) Does this have to be in a userform? You could achieve a similar result using SQL or PivotTables or dynamic dependant dropdowns. Happy to discuss further, but need to know a little more about what you want to do with the output.
2) You can get an EXCELLENT treeview from http://www.jkp-ads.com/articles/treeview.asp that replacing the Common Controls Treeview with an all-VBA counterpart.
 
Top