I'm trying to figure out the VBA for an idea I have; I can do this via the formulas easy but I'm trying to get around it with VBA inside a form!
I have a userForm that has a textBox where I place a date (e.g. 20-10-2017) and I would like a script to place a 1 month, 3 months and 6 months dates in to 3 different cells, is this possible?
In other words: I enter 20-10-2017 and 3 different textboxes give me different results: 20-11-2017 (1 month), 20-01-17 (3 months) and 20-05-2017 (6 months).
My textboxes are called:
StartDate: (I enter the date here)
Reminder 1: (automatic date placed)
Reminder 3: (automatic date placed)
Reminder 6: (automatic date placed)
Could someone point me in the right direction please? Thanks in advance.