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 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 for HackBulgaria Programming 101v3. The tasks were given some months ago, so I assume …
The book Power-Up Using Excel VBA Sorts and Searches: Advanced Techniques for Lightning Fast Sorts and Searches by Rich Locus presents VBA code, that can be used for Searches and Sorts. The idea behind the book is to present the commands VLookup, Match …
Book Review – Advanced Techniques for Lightning Fast Sorts and Searches Read more →
This weekend I have managed to finish the online version of the book “Python Programming Fundamentals”, kindly provided to me by Springer. In general, I have almost no experience with Python, so I have read the book with the eyes …
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 …
The book Excel Macro Mastery is an excellent book for non-programmers, willing to learn VBA. Indeed, it is written in simple English, following the 80/20 rule of Paretto in Excel, or as the author says, 99.9% of the time you …
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 →
In the current article, I show why it is convenient to use the Format as Table option in Excel. Pretty much, it enables a new feature – you may refer to the cells in it not by an address, but with the …
Simple Excel – Usage of column names for formulas 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 →
Prime Numbers Excel Function Prime numbers are numbers, divisible by themselves. In the current example I simply made an Excel VBA function telling us whether a number is prime or not. It works as a charm 🙂 Check the prime numbers between …
MS Excel has a pretty good search option – you have probably used the Ctrl+F option a lot. Anyway, in the current article I will show you how to generate your own Search Engine. Why would you need it? Because …
Plenty of times, when I open some someones Excel files I see something as a check column, where you have only “YES” and “No” as values. They check something and if you are used to it, it can be quite …
Excel – Usage of Checkmark with formulas and custom formatting 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 →
Sometimes you may wish to load a web page from Excel. Just for fun. Then you have probably googled it and you realized that the command “ActiveSheet.QueryTables.Add” exists. Then you simply decided to try it but, something did not happen …
Sometimes, you may want a button to perform different actions. It is quite easy to make one with an On/Off, but when you would like to make a button, performing 4 different actions in VBA, the story goes a little …
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 …
In this article I present the second solution from the homework from SoftUni – www.softUni.bg – concerning classes in C#. This is the task: Define a class Laptop that holds the following information about a laptop device: model, manufacturer, processor, RAM, …
In the current article, I will show you the code of a solution of one homework from the SoftUni (www.softuni.bg). The solution is built in YouTube and you may take a look at it, if you want to hear me speaking …
C# – Defining Classes Homework from SoftUni – Video Read more →
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 →
Code reusability is important in any programming language. The main idea is to write as little as possible for easier maintenance. And, as it sometimes happens, writing less is much more difficult, than writing a lot. In the current article, …
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 …