Formula for a date

E

ExcelConfussed

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

BrianB

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
 
F

Frans Gerber

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!
 
R

Ron Rosenfeld

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!
Click to expand...

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
 
Top