Hi All,

I'm hoping you may be able to assist.

I have a userform that when the user enters a date into textbox1, I'd like textbox2 to fill in with a date respective to the date in textbox1. I have this working in a normal excel sheet, but I'd like to remove formulas from the sheet and have them auto calculate in the userform. The formula I'm currently using is =A3+12-WEEKDAY(A3) this will always return the following Thursday of the next week.

Is anyone able to help?

Many thanks.

Kind Regards,
Quasis