A button on the page

  • Thread starter Thread starter hbaublit
  • Start date Start date
H

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.
 
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
 
Hi,

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