• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display grouped table in a form

D

dumitrudan608

New Member
Hi,

Is there any built in form controll that allows displaying data in a table like structure, but also grouped by a column, with the posibility to expand/collapse?

1. [work] I ask this question mainly in case of Excel VBA, but in this case this needs to be a built in controll as it will be a tool used by allot of poeple and I don't have the resources to install something on everyone's computer.

2. [learning] The same question for Visual Studio VB.net, is there any control that can be used with a User Controll (Windows forms) or side-pane, that allows grouping? I did put together something custom in a dataGridView, by applying a filter on the source DataTable, but it looks unpolished and cluncky as it needs 2 helper columns, and I have not found any elegant way to replicate the expand/collapse and element lines.
 
Back with Excel 2003 you used to be able to put a pivot table on a userform. No more.
It looks like you'd have to install something which you can't do.
Anyway, perhaps:
What reference do I need to choose to for additional userform - Microsoft Community
vba - Is it possible to use a Pivot Table in a userform? - Stack Overflow
 
You must log in or register to reply here.
Back
Top