New article: Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox
For a project I needed a quick way to display the content of an array to the user. I didn't want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. So I figured I'd put a listbox on a userform and make sure the column widths of the listbox resize with the data I want shown. That proved far from easy...
Wed, 14 May 2008 18:15:00 GMT |
Update: Name Manager (version 4.1, build 603)
Updated Name Manager: Fixed a bug: when hidden name is edited, it used to become unhidden. When one adds names and the filter is set to show hidden names, new names are hidden by default.
Tue, 13 May 2008 18:45:00 GMT |
Update: Name Manager (version 4.1, build 602)
Updated Name Manager: Fixed a bug in the used names filter avoiding false positives on names which resemble a column reference.
Tue, 13 May 2008 08:00:00 GMT |
Update: SetupUtility
Updated SetupUtility: Accounted for the fact the Application.UserLibraryPath does contain a trailing pathseparator, unlike any other path in Excel's object model.
Tue, 06 May 2008 10:55:00 GMT |
Update: Name Manager (version 4.1, build 600)
Updated Name Manager: Fixed a bug in the Areas filter.
Wed, 23 Apr 2008 15:45:00 GMT |
Update to Flexfind: Improved Userinterface
My free Flexfind tool for Excel has been updated to version 5.3, build 558. I've improved the UI and the selecting of found items.
Fri, 28 Mar 2008 13:45:00 GMT |
Update: Name Manager (version 4.1, build 599)
Updated Name Manager: I've Updated the unused names filter to include objects and VBA and fixed a bug affecting Excel 2000 users only.
Fri, 28 Mar 2008 13:45:00 GMT |
Update: RefTreeAnalyser
RefTreeAnalyser has been updated with hotkeys and improved reporting. Do you have a license? then get this free download to update!. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 10 Mar 2008 08:10:00 GMT |
Update: Name Manager (version 4.1, build 595)
Updated Name Manager: Fixed a bug regarding editing a name in R1C1 mode and changed the way the create name dialog works.
Wed, 13 Feb 2008 18:15:00 GMT |
Update: RefTreeAnalyser
RefTreeAnalyser has been updated with a help file and is now accessible through the cell rightclick menu. Do you have a license? then get this free download to update!. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Wed, 13 Feb 2008 06:10:00 GMT |
Update: Name Manager (version 4.1, build 594)
Updated Name Manager: Removed a control on a form that caused compile errors for some users.
Fri, 18 Jan 2008 19:25:00 GMT |
New page: Catching Paste Operations
You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find reliable is to catch all possible paste operations. But this isn't very easy, since there are a zilion ways to paste...
Mon, 17 Dec 2007 18:10:00 GMT |
New page: Excel Headlines
Now in one convenient place: the most recent references to articles from what I think are the most important Excel Blogs in the world.
Fri, 07 Dec 2007 18:10:00 GMT |
Update: Name Manager (version 4.1, build 590)
Updated Name Manager to add a tiny but very useful toolbar to the VBE, which enables you to select from available range names and paste into your code.
Thu, 06 Dec 2007 18:00:00 GMT |
Bijgewerkt: Name Manager (versie 4.1, build 590)
De Name Manager is uitgebreid met een o zo handig toolbartje waarmee je in de Visual Basic Editor een bereiknaam kunt selecteren in in je code laten plakken.
Thu, 06 Dec 2007 18:00:00 GMT |
New Tool: RefTreeAnalyser
Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 03 Dec 2007 10:55:00 GMT |
Een nieuwe Tool: RefTreeAnalyser
Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn.! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.
Mon, 03 Dec 2007 10:55:00 GMT |
Update to: Working with Tables in Excel 2007
I just learnt that using a table from workbook 1 in workbook 2 requires a special syntax. I have updated the article so it includes this information.
Wed, 14 Nov 2007 07:35:00 GMT |
Update to Flexfind: bugfix
My free Flexfind tool for Excel has been updated to build 552. Fixed problems with using wildcard search and replace.
Mon, 08 Oct 2007 14:15:00 GMT |
Een artikel op de Nederlandse "Microsoft voor ondernemers" website.
Dit artikel is onlangs (in het Nederlands) geplaatst op de website "Microsoft voor ondernemers". De link naar het artikel op de Microsoft site vindt u op bij het artikel op mijn site.
Fri, 28 Sep 2007 10:37:00 GMT |
JKP Application Development Services.
Subscribe in a reader