TM1 Forum

Longtime readers may be familiar with occasional problems with upgrades in TM1/ Excel/ Windows updates and subsequent problems with VBA form controls like treeviews, calendar controls etc. This is not just a problem in TM1 Perspectives but a general problem for Microsoft Office products. In response, some people in Excel-land have created an all-VBA treeview form control that is going to work across all versions. I would have thought this would be very useful for people in TM1-land who might benefit from this type of functionality - sometimes using E_PICK isn't going to get across the line.

Here is the link: An MSForms Treeview 2: Ready for beta testing

Indeed, fellow-MVP Jan Karel Pieterse and a few other Excel MVP's created this new treeview-like control. Good work !

Hi Wim, Daily dose of Excel is a great website and full of great tips, code and information for people who use Excel and also the TM1 Excel add-ins. Although it is the subject of ongoing speculation, people from the vendor have never raised dropping the Excel interaction and, unofficially, I always hear that it is set to stay as part of the stack. I guess if/ when Perspectives gets an overhaul they might look at stuff like E_PICK (mis-linked above) but until then stuff like this can be helpful in very specific situations. I get a lot of feedback that VBA + TM1 = BAD but in some situations it can still be a useful tool. What's your view on that?

Hello Robin,

You are right, DDOE is a very good website with lots of interesting posts. The posters are knowledgeable (many Excel MVP's).

Regarding TM1 and VBA, in general I like to stay away from the combo, because it won't work on the Web.
In Excel-only TM1 models, I could use it to automate things but in many projects, VBA work is very limited.
For example, I would prefer SUBNM over worksheet controls.

Wim