add a date to a second textbox

[Mon Wimp]

Hi again to all that help people like me.

2 textboxes in a userform.
textbox 1 already shows my date when the form opens,
textbox 2 is to show the date 14 days after the date in textbox1.
I end up in the year 1900.

any thoughts would help

Thanks Allan

 

[JamesW]

Hi,

What are you using at the moment?

This may help you:

TextBox2.Value = Format(CDate(TextBox1.Value) + 14, "dd/mm/yyyy")

 

[Mon Wimp]

excel 2007 @ work
excel 2010 @ home
Just did a quik one @ home and it works fine, so thanks for that James.
Allan

 

[JamesW]

Sorry, I meant what code are you using at the moment!

If it works at home though it should work at work.