Maxicus
04-11-2018, 11:35 PM
Hi
I am creating an maintenance inspection schedule userform, whereby the user can input the day the item was inspected. I am trying now to take that date entered and extend it for a specific period, whether it be monthly (30days) quarterly (90 days) or what ever the inspection frequency is required.
The dates are shown in textboxes.
I have tried the following code but it isn't working to well, because i believe it doesn't recognize the value of cur1 (textbox) as a date.
(extending the date with 30 days)
insp1.Value = cur1.Value + "30"
I have attached the workbook if that might help.
I am creating an maintenance inspection schedule userform, whereby the user can input the day the item was inspected. I am trying now to take that date entered and extend it for a specific period, whether it be monthly (30days) quarterly (90 days) or what ever the inspection frequency is required.
The dates are shown in textboxes.
I have tried the following code but it isn't working to well, because i believe it doesn't recognize the value of cur1 (textbox) as a date.
(extending the date with 30 days)
insp1.Value = cur1.Value + "30"
I have attached the workbook if that might help.