Formula for a date
 

Can anyone advice me on how get the current date to display in a field
when I open a excel template I created.

Formula for a date
 

Not sure what you mean by "Field".

Code :
Range("A1").Value = Format(Date, "dd/mm/yy")

or, a simple formula in a cell :-
=NOW() and format cell accordingly

--
Message posted from http://www.ExcelForum.com

Formula for a date
 

Thanks for your help. I guess by field I meant cell! The formulas you
gave me worked thanks. Can you also set it that the date will only
appear when you select that specific cell with the formula in it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Formula for a date
 

On Wed, 26 May 2004 01:59:37 -0700, Frans Gerber wrote:



Thanks for your help. I guess by field I meant cell! The formulas you
gave me worked thanks. Can you also set it that the date will only
appear when you select that specific cell with the formula in it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You could try an event-triggered macro like:

======================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, [A5]) Is Nothing Then
Range("a5").Font.Color = Range("a5").Interior.Color
Else
Range("a5").Font.Color = vbBlack
End If
End Sub
======================

Assumes your formula is in A5.

To enter, right click on the worksheet tab and select View Code. Paste the
above code into the window that appears.


--ron

Formula for a date
 

Great stuff thank you!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!