Browse by Tags

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

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

Adding RibbonX code to an Office OpenXML file using VBA

My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers… In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...] Read More...

Published Mon, May 05 2009 1:42 PM by Daily Dose of Excel

Filed under: Excel12, Classes, VBA Advanced, MVP, Downloads

Editing elements in an Excel OpenXML file using VBA

Hi Everyone! Today I finally found time to actually post a brand new article on my website. Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article. Enjoy!! Regards, Jan Karel Pieterse www.jkp-ads.com Read More...

Published Wed, May 05 2009 1:13 PM by Daily Dose of Excel

Filed under: Excel12, Classes, VBA Advanced, MVP, Downloads, Automation, File Operations

Syndication

Recent Posts

Tags

News

Archives