Thursday, March 13, 2014

Excel 64 bit treeview

I have developed some data entry tools in Excel. It has some VBA code and uses a TreeView component to select things like crops, countries, etc.


The underlying component is from MSComCtl i.e. Common Controls. Works like a charm as this is included in “all” Office installs. Well, not in the 64 bit versions. Some users have that version installed so this will not work for them. A work-around is to use the TreeView code from Jan Karel Pieterse.

In most cases there is no good reason to use the 64 bit version of Excel. It has similar limits on the numbers of rows and columns in a sheet. It can deal with spreadsheets with many more populated cells before running out of memory.