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
Bookmarks