Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a new page with a button? | Excel Discussion (Misc queries) | |||
Where is interactive button for save as a Web Page | Excel Discussion (Misc queries) | |||
page forward button | Excel Discussion (Misc queries) | |||
Command button dissapearing down page | Excel Discussion (Misc queries) | |||
Page Refresh button required (Macro..?) | Excel Discussion (Misc queries) |