Browse by Tags

RefTreeAnalyser goes 64 bit (and full circle)

Hi all, Some of you will be aware of my “killer” product called RefTreeAnalyser. It is a tool which makes it easier to navigate the precedents and dependents of a cell. Let me tell you the tale of how this tool has gone full circle. The original tool was written in VBA. I decided I [...] Read More...

Published Mon, Mar 03 2013 11:00 AM by Daily Dose of Excel

Filed under: MVP, .Net, Excel Advanced

An MSForms Treeview 2: Ready for beta testing

Hi everyone, Some time ago I announced I was working on “An MSForms Treeview” replacing the Common Controls Treeview with an all-VBA counterpart. This home-made treeview control will work on any Office version as of Office 2000, including 32 and 64 bit Office. I expect it will even work on MAC Office, but I’m still [...] Read More...

Published Fri, Feb 02 2013 10:20 AM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Downloads, User Interface, ActiveX Controls, UI Design, Excel Advanced

An MSForms Treeview

If you have ever used the Treeview control from the “Additional controls” section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: Compile errors due to a difference in how the control libraries are registered in 32 bits Windows’ System32 [...] Read More...

Published Thu, Jan 01 2013 4:24 AM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Visual Basic Editor, Windows API, Userforms and Controls, ActiveX Controls, Controls, UI Design, Excel Advanced

Excel 2013, SDI and modeless userforms

Hi Everyone, With Excel 2013 we also got new document windowing in Excel; Microsoft decided to make Excel behave the same as Word: from MDI: to SDI: This causes havoc when one shows a modeless userform which should stay on top of all Excel windows: I’ve devised a way to prevent this problem and written [...] Read More...

Published Mon, Nov 11 2012 10:16 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, User Interface, Windows API, Userforms and Controls, Excel Advanced, Excel 15

Working With Circular references in Excel

Have you ever experienced the dreaded “Circular reference warning” popping up when you opened an Excel file or entered a formula? Excel detects a circular reference when a chain of calculations visits the same cell more than once. Many users … Continue reading → Read More...

Published Wed, May 05 2012 11:24 AM by Daily Dose of Excel

Filed under: MVP, Formulas, Excel Advanced

Spot the 10 differences

Hi everyone! Yesterday I experienced the tedious task of figuring out what the differences are between the VBA projects of two different versions of a customer project I built a long time ago. Luckily there are tools to compare differences in text files, such as ExamDiff. But the VB editor doesn’t give you an easy way to [...] Read More...

Published Fri, Sep 09 2011 1:24 PM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, Automation, VBA Code Library, Excel Advanced

Syndication

Recent Posts

Tags

News

Archives