A button on the page

[hbaublit]

How do I make a button on my page that if I click it will put today's date in
the cell I want? I am using excel 2007.

 

[Shane Devenshire]

Hi,

I would prefer using the shortcut key Ctrl+; (control semi-colon)


1. First you need to add the Developer tab - press Alt+1, on the Popular
tab turn on the Developer tab in the ribbon.
2. On the developer tab choose Insert, Command Button and then click in the
sheet where you want the button
3. Double-click the button and put the a version of the following code
between into the subroutine

[A1] = Date

 

[Shane Devenshire]

Hi,

I forgot to mention, when you return to the spreadsheet turn off Design Mode
on the developer toolbar.