I don't see a way to put the date in toolbar, so I can quickly click on it
and have it enters today's date on a cell. thanks!
There's no built-in control to do that. You can type CTRL-; to insert
the date.
You could create a macro to do that and store it in your Personal Macro
Workbook or an add-in - is that something you're interested in? Perhaps
something like:
Public Sub InsertDate()
Const sFORMAT As String = "dd MMM yyyy"
If TypeOf Selection Is Range Then
With Selection.Cells
.Value = Date
.NumberFormat = sFORMAT
End With
End If
End Sub
Just put a Macro button on the toolbar and attach that macro to it.
