Creating macros in Excel is a fantastic way to automate Excel processes and save loads of time. However as your macros get bigger, you may need to speed up Excel macros execution.
This blog post looks at 6 ways that you can speed up your macros. You really need to know this stuff to create efficient macros in Excel.
If you are a user of Excel VBA already, then you may know all, or most of these. Please feel free to comment with the techniques that you use.
The Select Case statement can offer a neater and more concise alternative to nested If Then Else statements in Excel VBA.
So when you are performing complex logical tests, the Select Case statement can break it down into more logical chunks of code. This then makes it easier to write, read and understand what the code does, which everyone will appreciate.
In this tutorial, we will look at a few examples to show the different ways that the Excel VBA Select Case statement can be written.
[Read more…] about Excel VBA Select Case Statement with ExamplesAdd a single checkbox to select all checkboxes on a worksheet with one click.
If you have a large list of checkboxes, selecting all of the boxes, or removing the checks from all the boxes can be very time consuming.
This blog post will provide the code to select, or deselect, all checkboxes on a worksheet using a single checkbox, and explain how it works.
In this example we have the check list shown below.
These checkboxes are created using the form control on the Developer tab.
Check out this tutorial for more information on how to create an interactive checklist.
[Read more…] about Select/Deselect all Checkboxes with a Single CheckboxExcel PivotTables do not refresh automatically when the data source is updated. Learn how to automatically refresh PivotTables with Excel VBA.
Now, you can refresh all of the PivotTables in your workbook with just 2 or 3 clicks. But this is not something you need to do when you work with formulas, charts or Conditional Formatting. So you might forget, or just find it irritating to do it regularly.
This tutorial walks you through the VBA code to refresh the PivotTable automatically.
New to VBA and want to learn quickly? Sign up to our online Excel VBA course.
In this blog post we look at how to create a custom progress bar on a userform using Excel VBA, so that we can see the progress of our macros as they are running.
The progress bar will look like the one below. The fonts and colours used can be customised to your own liking.
There is a video at the bottom of this tutorial if you prefer to learn that way. Otherwise lets crack on and create this progress bar.
Download the completed file from this tutorial.
[Read more…] about Excel VBA Progress Bar on Userform
