Solved: Set Slider to Current Year

[Djblois]

I am using code to have my users choose the year. Most of the time the will be working with the current year. Right now I am setting the value Manually in the code to this Year. How can I set it so it chosses the current year?

With Me.sbYear
.Max = "2020"
.Min = "2000"
.Value = "2007"
End With

[lucas]

From the help file.....once again

.Value = Year(Date)

[Djblois]

Thanks for the help Lucas. I will give you that one-It was a lot easier to look for in the help than I thought it would be. I couldn't think of what to type into the box but it was pretty simple. My bad.

[lucas]

I don't mean to lean on you so hard Daniel but you have been here for a while and are not a beginner. I have followed you through several advanced procedures including development of addins :thumb ...I just expect more from you than from those with no experience at all.....:whip

I just searched for year in the vbe and year function was at the top of the list...

[Djblois]

Thank you and I understand but I am afraid to lose my training wheels. lol

[Aussiebear]

Training wheels.... so that's what those big round things are, that always seem to be beside me.

[mdmackillop]

Training wheels.... so that's what those big round things are, that always seem to be beside me. No Ted,
Those are beer kegs!:beerchug: