Did you find something
helpful on my site? Consider a donation!
Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!
Welcome to the website of
JKP Application Development Services.
We specialize in creating custom solutions based on your specifications.
Our main expertise lies with developing solutions using Microsoft Excel and Excel VBA, but creating applications using the other
Office programs is also possible.
Wij zijn gespecialiseerd in de ontwikkeling van applicaties op basis van
uw specificaties.
Onze belangrijkste expertise is het ontwikkelen van toepassingen in Microsoft Excel en Excel VBA, maar het maken van
applicaties met behulp van de andere Office programma's is ook mogelijk.
Update to Flexfind: Fixed a few issues My free Flexfind tool for Excel has been updated to build 560. I've fixed a bug in searching and replacing in chart series. Mon, 11 Aug 2008 18:45:00 GMTNew article: Fixing Links To UDF's in Addins Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called "User Defined Functions" (UDF). UDF's typically are placed in addins. As long as the addin is installed, the UDF's work as expected. You get into trouble when the location ... Mon, 02 Jun 2008 18:15:00 GMTNew 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 ... Wed, 14 May 2008 18:15:00 GMTUpdate: 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 GMTUpdate: 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 GMTUpdate: 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 GMTUpdate: Name Manager (version 4.1, build 600) Updated Name Manager: Fixed a bug in the Areas filter. Wed, 23 Apr 2008 15:45:00 GMTUpdate 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