- Home
- vba
Excel Option Buttons
It’s been a while since I posted about Excel macros, so I think it’s time I touched on this subject again. In this post we will add Option Buttons to a sheet and have that sheet change based on the selected option. With Option Buttons, only one option can be selected at a time. If […]
Continue readingAnimate In Excel
When creating a logo for my next site, I wanted to do it completely in Excel and then I later decided to animate in Excel. The logo itself is relatively straightforward using Excel’s shapes. The image below shows the final logo and also the shapes used to make it. I used Excel’s Drawing Tools to […]
Continue readingSum By Color in Excel
With improvements to the last few versions of Excel I see people using colors in cells more, the ability to filter by color adds to the benefit of using fill colors. However, the increasing use of colors has led to the increasing number of requests for help I receive to sum by color in Excel. […]
Continue readingSelecting Next Cells In A Different Order
If you have ever used Excel, you probably know already that you can move from your current cell to the one to the right, or below by using the tab or return keys. So what if you want to select the next cell, but the next cell is not in the normal order? For example, […]
Continue readingHow To Add Macros To Custom Toolbar
Having trained a variety people and helped others with macros, especially in Excel, I have noticed a common issue – assigning keyboard shortcuts to the most regularly used macros. Ctrl along with most of the letters are already assigned as shortcuts, by assigning for example Ctrl and B to your macro, this overwrites the […]
Continue readingExcel VBA Macro Demo
Starting from this post we have covered a range of areas relating to Excel VBA Macros. From the feedback received, it seems that people can see the benefits and uses of macros, but are still wary of them! As long as you record sections, breakdown code, comment it well, and have a search engine available […]
Continue readingExcel VBA : Debugging Errors
Debugging VBA Errors When creating macros in VBA, even if you just record one and amend the code you are almost certain at some stage to come across an error. When you run the macro you get a dialog box with an error message, it’s not as helpful as my example above, but at least […]
Continue readingExcel VBA : Working With Multiple Files
During the last few posts we have been building on our knowledge of Excel VBA Macros. This time we will use what we have already seen, but now we are going to work with more than one file. The Goal From this post, we will create a Billing file with a macro. This macro will […]
Continue readingExcel VBA : Finishing Our File – Comments, Borders & Column Width
If you have been following the series of posts so far, you should have a file like the above. A macro has changed the text in the headers, changed the format of the header row, added a formula in column D and a total at the bottom of column D using variables. This series started […]
Continue readingExcel VBA : Message Boxes & User Inputs
Message Boxes are easy to create and can be both informative and impressive to your program’s users. They appear as pop-up dialog boxes to your users and can give an update, information, warning, options, or other data. Similar to Message Boxes, are input boxes which allows the users to enter something to a dialog box, […]
Continue readingExcel VBA Macros : Variables
In VBA Macros, Variables are used to temporarily store information. This piece of information can be retrieved by your code and used or changed and then reused. In a lot of cases, using variables instead of setting values can make your code snippets and macros more reusable across files. For example, in a quiz you […]
Continue readingExcel Tip : Offset
In Excel there is a formula called “Offset”. This returns the value of a cell that is a given number of rows and columns away from a cell that you referenced. The syntax is =OFFSET(Reference, Rows, Columns). Reference is the cell you are going to refer to, or start from Rows is a number, it is […]
Continue readingExcel Tip : Ctrl And Arrow Keys
One of the keyboard shortcuts that I use most often in Excel allows you to quickly move around big spreadsheets by jumping to the start, end, top or bottom of the table. It is also the basis for some of the most repeated VBA Macro code snippets that I use. There are 8 shortcuts […]
Continue readingExcel VBA Macros : Your First Formula
The Story So Far… If you have been following this string of posts, you will have created a macro which has so far changed headings in a file and also formatted them. This is a link to the last post. At the end of the last post I also asked you to make some […]
Continue readingExcel VBA Macros : Format Text
The Story So Far… In our last post (click here to read it) we created a macro called “mySecondMacro”. This changed the 4 headings on our file to this… … and our Macro was this… If you have been following these posts you will already have a file saved as above. Or you can […]
Continue reading