If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|