Wednesday, April 17, 2013

An MSForms (all VBA) treeview control

Jan Karel Pieterse, Excel MVP, have built a treeview control on MSForms and VBA, which can be used as replacement for one from Microsoft Windows Common Controls. That means you can use it in both 32 and 64-bit Excel versions and also on Mac! As I see - you can also run it in Access, same way as in Excel, as dialog form, but not on Access form.

image

3 comments:

  1. Anonymous4:18 PM

    Looks cool Alex. I haven't tried it yet, but will soon.

    Graham R Seach

    ReplyDelete
  2. Anonymous6:01 PM

    FWIW, Jan Karel updated the page to include another download that supports Access form. It's mostly working; the only missing functionality that I know of is the scrolling and hopefully that'll be solved easy enough. -Ben

    ReplyDelete
  3. Thanks for update Ben, I was sure you make it :)

    ReplyDelete