Results 1 to 3 of 3

Thread: Replacement for TreeView

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Replacement for TreeView

    All
    I have been using both ListView & TreeView - but the 'MSComctlLib' or the common controls in the OCX is unstable - they are a real nightmare - especially if you develop on PCs with different OS.

    So I am now using a ListBox to replace my ListView - its ok.

    But I am wondering what is a good alternative for TreeView - I show the TreeView with Nodes. I do allow selection of multiple nodes - so I need like checkboxes or something to indicate what is selected.

    Any comments will be appreciated.

    I would prefer not to use a third party add-in or OCX - But I will if I have to.

    Thanks
    Rasm
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14
    Attachment 158Hi,

    I only use Excel 2003, but may include:
    First I would try to add the references of the objects used in VBA.
    Then follow the instructions of the Annex and enables the two voices.
    Note: I first turn of this procedure using the Listview I had complete control (for example, lacked the sort column)

  3. #3
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    PcMax
    I can get both ListView and Treeview working - the problem is their long term stability. Since they both are unstable - I have decided to replace them both. But I have not found a component that has the functionality I use in TreeView.

    So I am looking for a componet that will replace TreeView. Right now I will be using a combination of ListBox onjects - which is not pretty.

    Thanks
    Rasm
    xl2007 - Windows 7
    xl hates the 255 number

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. Replacement for the Flawed UsedRange Property
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 9
    Last Post: 12-04-2012, 08:09 PM
  3. TreeView Use With Database
    By Rasm in forum Download Center
    Replies: 1
    Last Post: 04-13-2011, 07:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •