Userform - Auto-populate text box

Hi There,

I think what I'm trying to achieve is pretty simple, but I've had no luck so far.

Basically I have two text boxes. textbox1 allows the user to input a date, textbox2 is supposed to auto-populate a date which adds 6 weeks (42 days) to the date in textbox1. I tried the below code but had no such luck .

Thanks for any help in advance!

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

TextBox entries by default are seen as a text string, so it must be converted to a format that Excel sees as a date

This will give a warning if a non date is entered in TextBox1

Please Login or Register  to view this content.

Glad it helped, please mark this Thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save