PDA

View Full Version : display label as Year & text


av8tordude
04-09-2010, 12:37 PM
In cell B11 is a date. I would like label1 to display cell B11 (year only) and Expense Summary Report.

Example: cell B11: 4/11/2010
Label1 Display: 2010 Expense Report

Any suggestion is greatly appreciated.
lucas
04-09-2010, 03:04 PM
Me.Label1.Caption = Right(Range("B11").Value, 4) & " Expense Report"