A button on the page
 

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.

A button on the page
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"hbaublit" wrote:

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.

A button on the page
 

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"hbaublit" wrote:

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.