In the current article, I will present the way to calculate the number of chars in a string with VBA. The inspiration came from the entry exam forHackBulgaria Programming 101v3. The tasks were given some months ago, so I assume it …
In the current article, I will present the way to calculate the number of chars in a string with VBA. The inspiration came from the entry exam forHackBulgaria Programming 101v3. The tasks were given some months ago, so I assume it …
VBA – Check distance between two chars in a string Read more »
In this rather small article I have decided to show how to take input from arrays for Excel custom formulas. In order to do this, I have decided to make a custom formula, calculating the second biggest number from a given sequence. …
VBA – Excel custom formula for second biggest value Read more »
As I have already mentioned in some articles here and there, in order to find something valuable and interesting to blog about, I convert tasks from C# into VBA. The C# task from the SoftUni looked like this: Define a class …
For quite some time I have decided to solve some of the C# competition exams of the SoftUni in Excel. The problem for today is called Cheat Sheet and you may find the description here. Long story short, you have to …
VBA – Excel – building a custom formula for C# competition exam Read more »
After the previous two articles, in which I have resolved two C# competition problems of the SoftUni, located here and here I have decided to resolve a new one. Pretty much, it turns out that it is really possible to …
VBA – Resolving C# competition problem with VBA and Excel (2) Read more »
In the previous article here I made a custom formula, building a plane in Excel. The idea for the article was inspired from the SoftUni entrance exam. Today I have done something similar – I found a challenge, where one was asked …
Today I have decided to resolve one of the competition problem of the C# basics exam of the SoftUni (www.softuni.bg) with Excel. I have shown how I have resolved a similar problem in C#, where you should have drawn a glass …
VBA – Resolving C# competition problem with VBA and Excel Read more »
Yesterday I wrote an article for an Excel function, checking whether a specified number is prime or not. Today I tought that it would be somehow a good idea to modify this function, in a way to check the number and …
VBA – Function to write the divisors of a number Read more »
There are a few ways to set a shortcut for a macro. The easiest one is through the menu Developer> Macros > Options, select the macro and write the shortcut: However, there is a better way to do this – with …
VBA – Set a shorcut for VBA sub procedure (macro) in Excel Read more »
For a reason, you may wish to simply add a value in an excel cell and to have it automatically summed with the value, that was previously present in the cell. This can be valuable, if you are building some …
VBA – Sum Values Entered in Excel Cell without Formula Read more »
VBA is an object-oriented language. As such, it is quite OK to create classes and to assign properties to these classes there. In the current article I will show how to create a class “clsPC” with three properties – Processor, Video …
How much time do you need to build something like this in Excel? At least 20 minutes + a lot of lost nerves for the formatting. Unless you use VBA and you build it within some seconds 🙂 Pretty much …
Every VBA programmer needs to know how to extract data from and to separate files. This is a really valuable knowledge, if you are building MS Office app, which is to be used by a third-party. In the current article I …
Today I was looking for a solution, giving me the option to locate a string, defined between two strings. Pretty much the story of any developer’s life. So, I found a really useful resource, which helped me to build my …
When you work with professionally built VBA tool, sometimes logging your actions (or the actions of some colleague) if the file is shared, can be of use. The idea is not to go into spying, but simply to check who …
VBA – create a log sheet of Excel with specific actions Read more »
Probably you have heard something about PHP. If you have, then you know that it supports arrays (and lists and anything you like) and you may declare any type of data in these. In VBA, usually the case …
The case – you have a multi-sheet Excel file, where you need to lock each cell in a given sheet. You have an option to do it manually, but it takes time and you need twice the time to check …
VBA – Locking and unlocking cells in a range – quickly Read more »
Talk to me, Excel! 🙂 Yup, MS Excel can talk. In my case with a computer voice, which is close to a female one 🙂 How can you make use of it? I propose with a custom formula, which simply …
This would be a rather small article. Roughly, what it does is to take all of the cells in given range and to join them one by one, in a way to display them in a shape. Still with me …
If you work as a VBA developer long enough, you may find quite interesting tasks to appear in front of you. Sometimes you have to merge horizontal cells with equal values. And because you are not going to do in …
VBA – Merge horizontal cells with equal values in Excel Read more »
I the current article I will simply present how to save the results from a filtered table in MS Excel in a separate text file. To do this you simply need some table as the following one, where you can …
VBA – Save text from filtered table in Excel in separate file Read more »
If you program with Excel and VBA, probably you have plenty of various functions, showing you how to access some of the file properties. Mainly file path and file name. With the current VBA module, you may see how to …
VBA – Excel custom functions – Document Properties Read more »
With the current article I will simple present some easy code, transferring Chart (diagram) to a picture. It is not something unusual, but sometimes it may be very handy, if you are trying to use the picture later. So, let’s imagine …
There are many ways to create a query in Access. However, creating a query with VBA code is something quite challenging. The code below creates an object of type query, named “MyQuery”. The SQL of the object is also given …
MS Access is something very … interesting. For the last week I was building something on it, which includes dealing with data in HH:MM:SS format. Access has a pretty good feature for dealing with this, but this feature somehow crashes …
VBA – Access – convert “HH:MM:SS” to double and back Read more »
Today I was building some Access DB, where I had to sum two variables in HH:MM:SS format. Then I had to multiply them by one integer and at the end to display them as HH:MM:SS once again. It seems really …
VBA – HH:MM:SS from Minutes – Format in Access(Excel) Read more »
Long long time ago, when I was building some Excel VBA spreadsheet tool for a leading retailer, I was having some cheat-sheet in Excel, in order to find the number of the column in Excel – e.g. A-1, B-2, C-3 …
VBA – Getting column name from number in Excel – Function Read more »
With the current article, I simply present a good way to list all the AddIns you have in MS Office, using VBA. Pretty much, I declare a string array and I redimensionize it. Then for each addin in the …
