Rebekah Oster shows a very simple VBA trick to get the Date Picker in Excel (an add-in created by Vertex42) to show, hide, and move around as you click on dates in your worksheet. This will only work within the worksheet where you have added the VBA code, but for something like a check register, log, or other type of transaction-oriented sheet, this is very cool!
1 year ago • Vertex42
4
0
6 years ago • Vertex42
This video (How to Make a Gantt Chart) is the start of what I hope will be an awesome new video series. This particular video shows how I created the essential elements of the "Simple Gantt Chart" that you can find either on my website or by going to File > New within Excel and searching for "gantt chart" Download the Template Here: https://www.vertex42.com/ExcelTemplat... Learn Excel shortcuts, tips, tricks, and features while watching us create useful templates. I will likely do quite a bit with gantt charts because they are useful for demonstrating a lot of different Excel features and formulas.
34
0