View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey .... Corey .... is offline
external usenet poster
 
Posts: 27
Default Add exactly 1 Year in days to Textbox date

How can i ADD 1 year to Textbox32's date entered and have it placed into
Textbox33 ?

Private Sub TextBox32_AfterUpdate()
TextBox32.Text = Format(TextBox32.Text, "ddd dd mmmm yyyy")
If TextBox32.Value < "" Then TextBox33.Value = TextBox32.Value ' <=== Gives
me an error
End Sub

Corey....