VBA is not a scripting language… Not at all!
You know, a lot of people nowadays should simply take loans. There are plenty of load calculators available online, but it is always better whey one can calculate this thing by himself. Or with Excel, which is pretty much the …
In this article I present a good possibility to customize your Active Window from Excel itself and not from the ribbon. By inserting some form controls, we receive a decent-looking customization dashboard like the one below: The idea of the …
Let’s imagine you are a supply chain manager of a company. You use 10 warehouses. Each warehouse has a number of pallets, it can accommodate. One day you decide to check what will happen if you simply reduce the numbers …
VBA – Quick & Impressive Recalculation of Total Sum – Video Read more »
VBA is not a perfect language – actually it is not exactly a language, but if you have worked 4+ years in Excel and then you have discovered it, it is probably like miracle for you! (especially if you have …
If you need to remove the print view lines, the easiest was is to do it with a macro 🙂 Actually, there should be other ways to do it and there are other ways definitely, but the workaround them (reading …
With this macro we do not actually add something new – it simply does something, which is quite useful if you are working with big documents where you should select the data, based on different values. In the current example, …
VBA – Excel – Activate Sheet Based on Value on Another Sheet Read more »
Changing formulas to values is something really easy in MS Excel – what the majority of people (including me) would do the following – simply record a macro, where you select all cells and paste them as values. The result …
If you work with VBA macros, you probably have a few lines of code, which you write before you start the actual coding. In this area we include turning off calculations, displaying alerts and screen updating. With other words, this …
Sometimes you simply want to do an action in a file to all sheets, but not to the two important ones, named “Important1” and “Important2”. In this case, you may use a simple for/each loop with a select case option. …
In this article I will simply combine two different subjects – creation of formula, displaying the name of the tab and hiding a specific range per each Excel sheet. Concerning the formula, here it is: =REPLACE(CELL(“filename”,A1),1,FIND(“]”,CELL(“filename”,A1)),””) Concerning the VBA code: …
VBA – Hide specific range per each sheet + formula for tab Read more »
Probably, if you are programming with Excel as much as me, one day you have the following question – all the pictures in Excel are generated by my code and I really do not care to give them names. I …
VBA – How to delete quickly all pictures from Excel? Read more »
With this article I will simply present you with a solution, combining HTML and VBA, exporting a graph from excel to MS Outlook e-mail. The HTML part is a little complicated and not very flexible, but anyhow – it is …
VBA – send an e-mail from Excel, using MS Outlook and HTML Read more »
With this short article I will briefly explain how to protect your VBA code from viewing from 3rd parties. It is as simple as that: 1. Open the Visual Basic Editor. 2. On Tools select “VBA Project Properties. 3. …
Have you ever had the case to develop a whole solution and at the end someone to tell you the following: “You know, it works well, just insert IFERROR and it is ready to be submitted.” Then you start rebuilding …
VBA – Excel – Adding “iferror” to many cells with one macro Read more »
In this article I will show how to check data through a VBA code in Excel, which is available in a closed MS Access file. Let’s imagine the following: 1. You have an MS Access database file with some random …
VBA – Reading information from a closed MS Access file Read more »
In this article I will continue the subject concerning VBA and MS Access. I have thought of a rule of a thumb, presenting only 3 macros per article, thus being sure that the reader does not get bored. Here I …
With this article I am going to present just a few easy Excel Macros, which I have found useful once. The first one is a typical example of loops in VBA and it creates an excel spreadsheet with tabs for …
VBA – Three easy Excel Macros which will make your life easier Read more »
Hello! In this article I will present a code for the easy export of selected cells into a HTML file. In general, the code functions in the following way: 1. Takes a look at the selected range and performs a …
Do you know that VBA can take over all the control over different MS Office applications? This is a simple example how you can open and close a Word application from Excel. In order to do this, you may use …
In this article I will show how to make custom MS Formulas. This is quite useful, if you want to use a formula, which is not available in the predefined Excel formulas. The inspiration for this article came, after I …
So, in this post I will show you a puzzle game in MS Excel – it is like the old one, the kids from the ’90s used to have, before we had PCs. So, the excel file is here, just …
Lesson 1 – VBA and Excel What is VBA? – VBA is something great, if you are working more than 1 hour with MS Excel and MS Access. It is simply said a must for everyone, who earns his money …