Adding number of days to date in userform textbox

[Capt_Antihero]

Hello,

I have a really simple problem that I need help with regarding dates on my userform.

TextBox1 = a date (which I need in mm/dd/yyyy format)
TextBox2 = a number (30 as an example - this is number of days)
Textbox3 = the date in Textbox1 + the number in Textbox2

So textbox3 will have a date in the format of mm/dd/yyyy and would be 30 days in advance of the date listed in textbox1

I'm not a novice so I'm frustrated that I can't get this to work - please help!

 

[My Aswer Is This]

Did you try:
textbox3.value=textbox1.value+textbox2.value

 

[Capt_Antihero]

Hello yes I have tried that, all that was doing was putting the numbers together, so when I had 06/01/2015 in textbox1 and 31 in textbox2 the result in textbox3 was 06/01/201531

I tried using Val(userform1.textbox1.value) + Val(userform1.textbox2.value) and with the same numbers above the result was the number 37 so it was just adding the 06 from the start of the date to the 31

 

[mikerickson]

Try

TextBox3.Text = Format(DateValue(TextBox1.Text) + Val(TextBox2.Value), "mm/dd/yyyy")

 

[My Aswer Is This]

Thanks for that mike. Another thing I learned today.

Try

TextBox3.Text = Format(DateValue(TextBox1.Text) + Val(TextBox2.Value), "mm/dd/yyyy")

 

[Capt_Antihero]

Try

TextBox3.Text = Format(DateValue(TextBox1.Text) + Val(TextBox2.Value), "mm/dd/yyyy")

thank you very much!