![]() ![]() ![]() (The switch for value changes from above is from there.). What I liked really much in the book, was the last two chapters – the last one was concerning some useful codes, that may increase your interest into VBA development. This saves time for the reader □ User defined functions, error handling and events were also explained on a level that would be understandable for a beginner. ![]() At a later stage I liked the way the message box and the conditional operators were explained together. At a later stage, the variables are explained, with some good explanation for Date and Time, which is a key variable in VBA ( and is not mistaken as in Excel, good work for Microsoft there). I myself do it rarely, but if I was accustomed to it from the beginning my performance would have been higher. If you are new to Excel VBA, try to make a habit to use the Watch window, it would be of use later. ![]() “do not copy a single cell value to another cell, but use Range(“ a4“).Value – Range(“ a3“).Value”. This was worthy! Some valuable tips for beginners were given, that save a lot of time – e.g. It was explained with the Excel shortcuts and the VBA code, which actually runs them.Į.g. I liked the way the range selection was thoroughly explained. The screenshots of the Kindle edition were clear and easy to understand. It simply takes the status of the column and makes it reverse. I was doing this with if, but the current code is way better and faster. if a column is hidden, it makes it not hidden and vice versa. Creating a “switch for value changes – this is simply a macro, which takes into account the current state of a given TRUE/FALSE feature and returns it with the other one.Thus, the code is recorded with offsets, based on the current selection. The “Use Relative References” possibility for recording a macro – a good option, if you want to avoid hardcoding of the range.The fact that if you record a macro in excel in the Personal Macro Workbook, it would be recorded into a Personal.xlsb file, loaded when Excel starts and available for all workbooks, as shown in the next two screenshots:.The things I did not know before reading: As far as this one was for non programmers and I am not exactly a non-programmer, I was really interested what it can teach a person with no idea in VBA and I tried to find at least 3 VBA tricks I did not know. That is why I am always eager to take a look into the VBA books and to review them in my site. The current article reviews a VBA book for MS Excel.įirst things first – I am not sure what should be done to pursue the non-IT people, that VBA is not something difficult and every hour you spend, trying to master it would pay out by saving 20 others, pressing ctrl+arrows and copying endless ranges in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |