Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to make the Today() function static
I would like to have a cell enter the current date when I make an entry in
another cell, but I would like it to be static. The today() and now() both seem to be volatile. I know that I could use cntl ; but I would like it to be entered automatically. Thanks -- Jeff Ciaccio Dallas, GA (W) 770-591-6819 x-274 http://mywpages.comcast.net/ciaccio8515 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to make the Today() function static
Jeff,
Apart from mis-spelling your name (sorry!), I forgot to mention that this code, if you choose to use it, should go into the applicable sheet module. To get to this, right-click the sheet tab, and select the View option. This will open the sheet code module, so then paste the code I gave into the code pane. Also, if you don't want the time, just use Target.Offset(0, 1).Value = Format(Date, "dd mmm yyyy") -- HTH Bob Phillips "Bob Phillips" wrote in message ... Jedff, VBA okay. This adds the datre to one coluimn right if achange is made to A1:A10. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False On Error GoTo ws_exit If Not Intersect(Target, Range("A1:A10")) Is Nothing Then If Target.Count = 1 Then Target.Offset(0, 1).Value = Format(Date, "dd mmm yyyy hh:mm:ss") End If End If ws_exit: Application.EnableEvents = True End Sub -- HTH Bob Phillips "JC Home" wrote in message ... I would like to have a cell enter the current date when I make an entry in another cell, but I would like it to be static. The today() and now() both seem to be volatile. I know that I could use cntl ; but I would like it to be entered automatically. Thanks -- Jeff Ciaccio Dallas, GA (W) 770-591-6819 x-274 http://mywpages.comcast.net/ciaccio8515 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the Today() function static
-----Original Message----- I would like to have a cell enter the current date when I make an entry in another cell, but I would like it to be static. The today() and now() both seem to be volatile. I know that I could use cntl ; but I would like it to be entered automatically. Thanks -- Jeff Ciaccio Dallas, GA (W) 770-591-6819 x-274 http://mywpages.comcast.net/ciaccio8515 Jeff, I assume you are familiar with the vba environment in Excel. Go ahead and go into the VBA environment (ALT+F11). Dbl Click the worksheet you want to do this with. Select Worksheet in the combo box at the top left. Goto the Worksheet_Change. Do something like the following: IF Target.Col=X and Target.Row=Y THEN Target.offset(0,5)=str(Date) 'go over 5 columns and place date stemp. END IF -Paul |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to make the Today() function static
On Thu, 24 Jul 2003 15:38:03 -0400, "JC Home" wrote:
I would like to have a cell enter the current date when I make an entry in another cell, but I would like it to be static. The today() and now() both seem to be volatile. I know that I could use cntl ; but I would like it to be entered automatically. Thanks Record a macro where you type =now()into any blank cell, copy, paste-special/value. Anywhere you want to insert a static date, select that cell and run the macro. Assigning that mcro to a key combination makes it really easy to use. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make "NOW" function static | Excel Worksheet Functions | |||
How can i make excel to highlight today using conditional formating | Excel Worksheet Functions | |||
How to make toolbars static with IE7 | Excel Discussion (Misc queries) | |||
How to make the Result of a TODAY Function static? | Excel Worksheet Functions | |||
How do I make the now() static and not change with calculation? | Excel Worksheet Functions |