UserForm design for the Excel Soccer Planner Addon
Today, the second article of my series on the development of the additional tool for Excel Soccer World Cup 2010 Planner. Those who deal with Excel VBA, are certainly aware that own forms or UserForms can be created and be filled with controls. The design of the controls and the UserForm lies on older Windows versions and is - in my opinion - by its appearance a little bit boring. Below is a screenshot of the same UserForm, on the left side you can see the default design and on the right side an alternative variant.
Continue…
VBA Add-In for highlighting rows and columns in an Excel sheet
For some time now, I'm evaluating my web server log files with Excel 2010. Yes, there are many other good tools for analyzing logfiles on the market and I'm also using some of them. However, Excel 2010 provides the function to easily import and filter the raw data of my logfiles. Unfortunately, with such amount of data, I'm often „loosing“ the line while reading on the screen. Ok, I can surely increase the zoom factor of the sheet or setup borders for the cells; my wish was, however, to have a tool which highlights the current line or column. As Excel does not provide such a feature, I decided to implement my own tool in VBA. The following screenshot shows the tool in action:
Continue…
Custom VBA Tooltips for an Addon for the Excel Soccer Planner
Some of you have probably heard of our Excel Soccer World Cup 2010 Planner for the soccer world cup this year in South Africa; a conjoint project of my friends and me. I had recently announced an additional Excel VBA tool for the planner, which will, for example, be able to import and export predictions from the prediction game or send queries to a web server.
Now I had the idea to involve all interested people in the development of this tool by writing articles, how choosen features are implemented in this tool. I will also present parts of the code and at the the end of this series of articles I will write a post resuming the other posts.
This article starts with presenting a solution how to write custom tooltips using VBA. The following screenshot shows a sample of these tooltips from the options dialog in Word 2010. When you move the mouse cursor over the icons containing a small "i", a text explaining the function of the setting appears.
Continue…
Creating UTF-8 XML files in VBA for use in Adobe Flash
My partner - www.designimsinn.de (German) - and me have recently redesigned and implemented an Adobe Flash based CD for one of our customers. This multilanguage CD (German, English and Russian) contains many external documents to the CD interface and stored in several subfolders on the CD. However, the user should be able to access and open these documents directly from the CD interface application by clicking on specific buttons or by clicking on listbox items.
During the project I had the idea to develop a small Excel tool that simplifies the management and generation of document keys, INI files and XML files which may be used for accessing the documents from Flash. This article describes the framework conditions and the tool. Ok, this application is specially designed for our project. However this Excel Tool can be downloaded at the end of the article and the VBA project is not protected. Maybe someone can use the tool with a few modifications for his own projects, or perhaps the code may be useful for study purposes.
Continue…
Hide and unhide objects in Excel
The panes shows you all objects in the current sheet, you can hide and unhide them by clicking on the eye buttons on the left side of the pane.
Continue…
Blog
News
