In this Excel training video, we guide you through the process of enabling the developer tab in both Windows and Mac desktop versions of Excel. We’ll also show you how to use some of the common developer tools that can help you take your Excel game to the next level.
Once enabled, we’ll show you how to utilize add-ins, form controls, and Visual Basic for Applications (VBA). By the end of this tutorial, you’ll not only have the developer tab readily available but also the skills to harness its tools effectively.
PSST, HEY, YOU
(YEAH, YOU!)
Want in on insightful videos, the latest tech developments, and epic exclusive content? Get all this and more as a member of our mailing list.
Resources
VBA code to add current date & time to selected cells:
Sub AddDateTime()
Dim selectedRange As Range
Set selectedRange = Selection
If Not selectedRange Is Nothing Then
For Each cell In selectedRange
cell.Value = Now
Next cell
Else
MsgBox "Please select a range of cells.", vbExclamation, "Selection Required"
End If
End Sub