Year question

[Greg B]

I am having problems working out a simple little sum. I have a userform
when I have a new member join I want it to add the current year. How can I
get excel to do this the easy way. I currently have it paste the now()
value and have set the cell to show yyyy but unfortuantely when I go to the
next cell where I want to have the worksheet work out the years member
section it comes up as volitile.

Any Ideas

Thanks

Greg

 

[Norman Jones]

Hi Greg,

With Range("A1")
.NumberFormat = "General"
.Value = Year(Date)
End With

Change A1 to the cell of interest.

 

[pinmaster]

Hi,
I'm not an expert but maybe something like this in your code:
Activecell.Formula = Year(Now())

HTH
JG

 

[Greg B]

Thanks Norman work great

Greg

Hi Greg,

With Range("A1")
.NumberFormat = "General"
.Value = Year(Date)
End With

Change A1 to the cell of interest.