| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Treeview in excel
Can I programatically set this from vb?
"Marcotte A" wrote: "Chris" wrote: Hi, Is it possible to have a treewiew display in excel. I have quite a lot if data to display and I want to group them so that when a user click on one of the group it shows detail info of the group. I am trying to revise an excel file that is done manually so that it takes the data from sql server. Thanks Under the Data menu, take a look at "Group and Outline..." Not sure if this will suit your needs, but you can group rows or columns together so that you can Hide/Unhide them with one click. I use it for spreadsheets with daily data. I group each week, so I can hide them and just see the weekly subtotals, then expand them when I have to enter data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TreeView in Excel VBA | Excel Discussion (Misc queries) | |||
| Treeview in excel | Excel Programming | |||
| Treeview control in an Excel form | Excel Programming | |||
| TreeView | Excel Programming | |||
| Treeview | Excel Programming | |||
Linear Mode
