Calendar value
 

I have a userform in Excel 2003 that i need to select a start date.
when I click the calendar control it puts he date into a txtStart.

what I can not figure ouit is how to add 30, 60 or 90 days to that value
which will
also be in text box.

any help on this matter is greatly appreciated

thank you all in advance

Calendar value
 

Hi HellZg8,

Try:

'=============
Private Sub Calendar1_Click()
With Me.Calendar1
txtStart.Value = .Value
txt30 = .Value + 30
txt60 = .Value + 60
txt90 = .Value + 90
End With
End Sub
'<<=============


---
Regards,
Norman


"hellZg8" wrote in message
...
I have a userform in Excel 2003 that i need to select a start date.
when I click the calendar control it puts he date into a txtStart.

what I can not figure ouit is how to add 30, 60 or 90 days to that value
which will
also be in text box.

any help on this matter is greatly appreciated

thank you all in advance

Calendar value
 

Norman your a genius
thank you for a very quick response

works like a charm.

I can not believe how much help I have gotten from everyone on this site

to all who have acknowledged my lack of Excel VBA experience
once again I thank you all