VBA – RegEx in Excel
There is a well-known joke in the IT world – if you have a problem and you try RegEx to solve it, now you have two problems. Still, RegEx in VBA (and thus in Excel) exists as an additional library. …
Tag: VBA
VBA – Change Conditional Compilation Arguments in Access
VBA is not a scripting language. It compiles. As such, it has compilation arguments, which can be changed through code or manually. In MS Access you may find these here: VBEditor>Tools>VBA Project>Database Properties: If you want to use them for …
VBA – Change Conditional Compilation Arguments in Access Read more »
VBA – Listing all procedures in all modules
Sometimes you need to unite two projects into one in VBA. In these two projects, if you are using similar “own built libraries” you are in a kind of trouble. The trouble is called Compile Error :Ambiguous name detected: name Then …
PowerPoint VBA – Format All Forms in the active slide
In Powerpoint sometimes it is a bit boring (or challenging), when one has to make the shapes in a presentation the same size and to drag them to the same position. As far as there is no macro recorder there, …
PowerPoint VBA – Format All Forms in the active slide Read more »
Excel VBA – Search and highlight text
Sometimes we have an excel file, where we want to highlight anything, matching a given cell. Without using the search & highlight option, if possible. Like this: Thus, in this case, whenever something in range A1 is written, the values …
Excel VBA – Activity Selection Algorithm
Wikipedia says that the activity selection problem is a combinatorial optimization problem concerning the selection of non-conflicting activities to perform within a given time frame, given a set of activities each marked by a start time (si) and finish time (fi). The problem is to select the maximum …
Excel VBA – NetworkDays Formula
In Excel, there are plenty of ways to calculate the differences between days. However, the NetworkDays Formula includes weekends and may include the holidays, which would be different for each country/province. Thus, it is useful! Here is how to use …
VBA – Knight’s tour algorithm with Excel
Wikipedia says the following for the Knight’s tour : A knight’s tour is a sequence of moves of a knight on a chessboard such that the knight visits every square only once. If the knight ends on a square that is …
VBA vs C++ function – which one is faster in Excel?
Comparing the speed of VBA and C++ in general is quite not fair. Its like comparing the speed of a military jet and a Boeing 767. But still, it’s interesting to see how much C++ is faster in Excel’s native …
VBA vs C++ function – which one is faster in Excel? Read more »
C++ – Adding C++ function to VBA/Excel
After adding a c# library to VBA I have decided to take a look how to do a similar trick with C++. C++ is a bit fancier in a way. And it works somehow else. So, let’s start. Imagine that we …
Oasis SVN – Software Review – with Video! :)
In VitoshAcademy I try to be on the edge of VBA technologies. Unfortunately, this is not that difficult, as far as VBA is really like the hated child of Microsoft – it works quite a lot and it does a pretty …
Review – vbWatchdog – professional error tracking tool
As a VBA Developer, I am always interested in the latest technologies in the VBA world. This is not that difficult, as far as there is not plenty of new stuff there, thus whenever I see something interesting, I try …
Review – vbWatchdog – professional error tracking tool Read more »
Excel VBA – Floating Point Numbers in Excel – Not Exact
Everyone works with floating point numbers daily. If you go at a supermarket, the prices are like this: 11 eur 29 cents, 23 eur 35 cents and etc. As a C# developer and a blogger, I knew that there is some …
Excel VBA – Floating Point Numbers in Excel – Not Exact Read more »
VBA – The perfect userform in VBA
Somewhere in the summer of 2012 I have started coding in VBA. A little less than 5 years have passed since that very moment when I have pressed Alt+F11 for a first time and I have entered another Excel world. …
VBA – Code stops unexpectedly with “Code execution has been Interrupted” – Ghost Break
Ghost breaks in Excel can turn you crazy. Probably. If you do not know what to do and how to google them. Pretty much your code is perfect, it has worked 1000 of times, it compiles perfectly and still you …
VBA – Code stops unexpectedly with “Code execution has been Interrupted” – Ghost Break Read more »
VBA – Protect your code – Unviewable+ and the Ribbon Commander
Let’s state it straight every VBA developer is happy, when he can protect his own code. The VBE password is not secure protection, everyone with a few free hours and a good internet access can go around it. Thus, I was …
VBA – Protect your code – Unviewable+ and the Ribbon Commander Read more »
VBA – Add a C# library to a VBA project – Part 2
After writing the simple part here I think that it is a really good idea to introduce IntelliSense as well 🙂 Something like this in the code: And like this is in the library: The question is always one …
VBA – Add a C# library to a VBA project – Part 2 Read more »
VBA – Generate numbers in given columns
Imagine you have a spreadsheet with some numbers in it. And you need to read the first 130 numbers in the first 7 columns and save them in a list. Or something similar. Quite a strange task, but it happens …
VBA – Too many different cell formats
Sometimes with Excel you receive an error message, saying “Too Many Different Cell Formats”. This is really hard to believe, because you have not done something bad or strange and yet you cannot finish your action. Still, Microsoft knows about …
VBA – Bayan Bus Algorithms
Some one year ago there was something called Bayan 2015 Contest, published in codeforces.com. Thus, I have decided to solve one of the contest problems with VBA in Excel. And actually, as expected I have managed to do it! 😀 …
Book Review – Excel VBA 2013: For Non-Programmers (Programming in Everyday Language) – Second Edition
Some time ago I have reviewed the first edition of Excel VBA for non programmers. Thus, I was really flattered when the author has asked me to review the second edition as well. 🙂 The strong sites from the first …
VBA – Depth-First-Search Algorithm with VBA
Depth first search algorithm is one of the two famous algorithms in graphs. I am now in “Algorithm Wave” as far as I am watching some videos from SoftUni Algorithm courses. In the current article I will show how to …
VBA – Longest Increasing Subsequence
The longest increasing sub sequence is a well-known problem in computer science, its Wikipedia page is translated into 9 languages. 🙂 Thus, as far as I am watching some programming and algorithms courses in the SoftUni, I have decided to …
VBA – Draw with Excel – Competiton Challenge
At the beginning of January 2015, the Software University has decided to carry out an IT Olympiad. The competition problems and their solutions in C# are available here. In this article, I will present a way to resolve the second problem …
VBA – Interfaces in VBA How And Why?
Interfaces in VBA are something extremely rare. So far, as a VBA developer with about 3 years of developing experience (e.g. being paid to code, and not coding for fun) I have seen only one other developer to use classes …
VBA – Picture in ActiveX Control from Excel
Today I have tried for some time to do the following – make a picture ActiveX controller change, following the results of a dropdown button. The problem is that the picture ActiveX controller expects a path to the picture file, …
VBA – A* search algorithm with Excel – Really?
Today, some hours ago I saw the implementation of the A* search algorithm with Java, made by a classmate (or colleague) of mine. It looks like this: Thus, I have thought that for the reading of the Python Algorithm book, …
VBA – Probability Simulation of Two Dice
Throwing dices used to be a way to gamble. Nowadays, with TexasHoldEm all over the internet, this game is forgotten 🙂 Probably for good. Anyway, at the beginning of statistics every student is required to resolve some problems, containing dice, cards or …
VBA – Reverse colors in MS Excel
Today I was working with the Excel color styles and I tought that they are actually pretty well made. But for some reason I wanted to have a reverse of the styles and I did not want to waste time to define a …
VBA – Sorting VBA array – Functions in VBA
In the current article, I will show how to resolve with VBA an entry exam for programming in HackBulgaria. The problems could be resolved in any language and I will use VBA for this last task. The program is actually the …