The golf courses aren’t too crowded here this summer, because of the social distancing rules. So, if you’re trying to spread out the players at your course, use this Excel workbook for golf tee off times.
Category: Excel VBA
Add Filter Commands at Top of Right-Click Menus
Do you spend lots of time in Excel tables, filtering the data, then clearing those filters later? If so, this free add-in from AlexJ will help you save time. The add-in will add filter commands at the top of right-click menus, where they’re easy to use.
Continue reading “Add Filter Commands at Top of Right-Click Menus”
Excel Custom Function UDF Causing Problems
Excel macros ran really slowly in a workbook that someone sent to me. They said it was an Excel custom function (UDF) causing problems. The UDF ran for no apparent reason, and slowed other macros down. Here’s what I did to make things a bit faster.
Continue reading “Excel Custom Function UDF Causing Problems”
Change Excel Shape Colour Automatically
We all want to be remembered for our contributions to humanity. That’s why, way back in 2004, I made an Excel Smiley Face sample (aka “Happy Face”). There was a new version in 2009, and here’s another update, to change the Smiley Face shape colour automatically. You can do the same thing with other shapes too, like partial circle “pie slice”. Is there a Nobel Prize in this category?
Change Sheet Names in Excel Macro Code
If you download one of the sample Excel workbooks from my Contextures website, you might want to customize it, to meet your requirements. The two videos below show how to customize one of my files, and you can make similar changes in other workbooks. Continue reading “Change Sheet Names in Excel Macro Code”
List All Excel Files with Dates
Last week, someone asked if I could stop zipping the sample Excel files that you can download from my website. Well, I thought about it carefully, and decided to leave things as they are. Excel helped me decide, and you can get the macro that I used, to list all Excel files with dates and sizes.
Show Excel UserForm Automatically When Workbook Opens
You can add a UserForm to your Excel file, so it’s easy for people to enter data, without going to the table where the historical data is stored. Usually, I add a worksheet button that opens the form. But, with a simple macro, you can show Excel UserForm automatically, when workbook opens.
Continue reading “Show Excel UserForm Automatically When Workbook Opens”
Add Month Sheets Automatically in Excel
Set up a Master sheet in your workbook, and add month sheets automatically, based on that Master sheet. The new sheets will be named for the month and year, in yyyy_mm format.
Excel UserForm Builder Add-in
If you’ve purchased a copy of my UserForms for Data Entry kit, there’s a new bonus for you — the UserForm Builder (UFB)Â add-in. Watch the video below, to see how it works, and download the latest version of the kit, to try it out.
Get Data from Excel Button Clicks
Here’s a simple example that shows how you can get data from Excel button clicks. There are 3 buttons on one sheet, and if you click one, the date and time are recorded on another sheet, along with your name and the button number.